Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
Hi @MattAllington thanks for reverting back to my query, it doesnt seem to work with a measure pls see attached.
You can write CALCULATE(max(tableName[measure]),All(tableName))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |