cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

How to calculate the Maximum and Minimum of a measure

Hello-

 

I have the below data set, i would like to get the maximum and minimum value for the Measure 

Table 1

ID    Measure 

1      5

2      6 

3      7

4      8.5

5      9

6      10

 

I can use the below formula to get the max value of 10, but when a slicer/dropdown  filter is applied for the ID then the value that i get is for the selected filter ID and not max for the whole table. What do i do so that even if a page level filter is applied then i can get the value of 10 (Max) of measure, 

Max Manage Education Score = MAXX(
    All(Table 1 [ID]),[Measure]
)
 
Thanks
1 ACCEPTED SOLUTION
Helper III
Helper III

I was able to find it out, it is as follows CALCULATE(MAXX(
All(Education_Metrics[Company_RecID]),[Tiered Manage Education Score]
),ALL(Education_Metrics))

View solution in original post

4 REPLIES 4
Helper III
Helper III

I was able to find it out, it is as follows CALCULATE(MAXX(
All(Education_Metrics[Company_RecID]),[Tiered Manage Education Score]
),ALL(Education_Metrics))

View solution in original post

Helper III
Helper III

error_3.png

Helper III
Helper III

Hi @MattAllington thanks for reverting back to my query, it doesnt seem to work with a measure pls see attached.error2.png

You can write CALCULATE(max(tableName[measure]),All(tableName))



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.