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!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!