https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Hoogste-kleinste-en-gemiddelde-berekenen/m-p/871571#M7226 <P>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.</P> Wed, 11 Dec 2019 05:30:29 GMT kentyler 2019-12-11T05:30:29Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Hoogste-kleinste-en-gemiddelde-berekenen/m-p/864937#M7042 <P>Can someone help me to calculate the highest, smallest and average value in Power BI.<BR />Attached is an image, I want to calculate the highest, smallest and average value of the part marked in yellow.</P><P>&nbsp;</P><P>&nbsp;</P><P>Alvast dank.<img /></P> Tue, 10 Dec 2019 07:17:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Hoogste-kleinste-en-gemiddelde-berekenen/m-p/864937#M7042 Emel75 2019-12-10T07:17:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Hoogste-kleinste-en-gemiddelde-berekenen/m-p/871571#M7226 <P>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.</P> Wed, 11 Dec 2019 05:30:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Hoogste-kleinste-en-gemiddelde-berekenen/m-p/871571#M7226 kentyler 2019-12-11T05:30:29Z