How to compare the results of a measure with different filters

[AndreCantao]

Hello,

I have a measure that calculates the quartiles of a dataset.
I can filter it by hour of day (24 possibilities) and type of day (3 possibilities), which means I have 72 combinations of filters.

Now I would like to get a measure that run the first measure 72 times and compares the values (highest or lowest).

Is it possible?

[Greg_Deckler · Accepted solution]

@AndreCantao This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

[AndreCantao]

Thank you for your answer. That is exactly what I needed.