Skip to main content
Microsoft Idea

    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