Calculate a DAX measure minimum in a group

Hoszi — Wed, 05 Jun 2019 04:28:28 GMT

Hi!

I've to calculate the percent of good items, see above. The Measure_Good_Perc value is a DAX measure.

Group	All_Item	Good	Measure_Good_Perc
A	37	35	94,59%
B	308	238	77,27%
C	51	31	60,78%
D	70	57	81,43%
E	56	30	53,57%
F	28	21	75,00%

I have to make two measure which shows the minimum and maximum value of Measure_Good_Perc in the range of the groups (in this case the min is 53,57% and the max is 94,95%). The groups are dynamic, controlled by many slicers.

Thanks for the help.

Re: Calculate a DAX measure minimum in a group

parry2k — Wed, 05 Jun 2019 14:27:10 GMT

Hoszi try following two measures, it might required tweaking since dont know the whole data model/tables/relations etc.

Min Good % = 
MINX( VALUES( Table[Group] ), [Measure_Good_Perc] )

Max Good % = 
MAXX( VALUES( Table[Group] ), [Measure_Good_Perc] )

topic Re: Calculate a DAX measure minimum in a group in DAX Commands and Tips

Calculate a DAX measure minimum in a group

Re: Calculate a DAX measure minimum in a group