Skip to main content

Power BI

Needs Votes

Add Option to Define Visual- and/or Page-Level Measures

Vote (2) Share
Pat M's profile image

Pat M on 19 Dec 2020 13:28:14

It would improve performance if there the ability to calculate measures at the visual or page level that could be referenced by the calculations within the visual. A simple example would be to have a visual level measure with

Visual Measure = CALCULATE([Measure], ALLSELECTED(Table[Column]))

And in the visual, have

Item Measure = DIVIDE([Measure], [Visual Measure])

So the visual measure is evaluated once for the whole visual.

Comments (2)
Pat M's profile image Profile Picture

Pär Adeen on 12 Oct 2023 07:48:20

RE: Add Option to Define Visual- and/or Page-Level Measures

Agree Just let us create our own implicit measures. This is e.g. useful for creating dynamic texts for headings etc without cluttering the data model

Pat M's profile image Profile Picture

Al B on 19 Dec 2020 14:14:42

RE: Add Option to Define Visual- and/or Page-Level Measures

Good idea Pat.
An example of a use case where this would be useful can be found here:
https://community.powerbi.com/t5/Desktop/Optimizing-PERCENTILEX/td-p/1548703
Best