Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Can someone help me to calculate the highest, smallest and average value in Power BI.
Attached is an image, I want to calculate the highest, smallest and average value of the part marked in yellow.
Alvast dank.
So you would probably need one measure for each calculation. DAX has MAX MIN and AVG to do the calculation... the issue would be that if you put the measure in the visual it would have a filter context that would restrict the values available for the calculation to that row. The way out of this would be to use the function ALL() to remove that context when you apply the 3 functions.
Help when you know. Ask when you don't!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
20 | |
18 | |
17 | |
17 |
User | Count |
---|---|
35 | |
21 | |
19 | |
18 | |
10 |