How to calculate the Maximum and Minimum of a measure

[Hitesh1604]

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

[Hitesh1604 · Accepted solution]

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

[Hitesh1604]

[Hitesh1604]

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

[MattAllington]

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