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)
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
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