how to calculate the min value for a measure that compiles averages

[cuseman03]

Hi all, going nuts trying to figure this out and it should be simple.

i have the notion of a group 1, group 2, group 3, etc.  each group has an average percent.  I have a measure for that just fine.  So let's say the values are group 1 = 70%, group 2 = 93%, and group 3 = 14%, I simply want a measure to obviously select the lowest value, that being 14%.

Further more, I have a filter option with check boxes for group 1, 2, 3, etc.  I want this lowest value to remain constant so regardless of which group you select in the filter, the lowest value is always shown.  have tried minx, summarize, can't get it.

whew...

Thanks,

[mahoneypat]

Have you tried this measure expression?

Group Min = MINX(ALL(Table[Group]), [Avg Percent Measure])

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[lbendlin]

As the russian proverb goes "It's not harmful to want".

Keep in mind that you are dealing with measures here, so there is no way for you to store any information. You have to recalculate everything every time.  There goes your slicer idea...

just saying "it should be simple"  doesn't make it so.  Go at it methodically, step by step. Use lots of variables and lots of concatenatex() to validate that the variables are returning the expected intermediate results.