Forum Discussion
Apply Dynamic Threshold Filter to Measure
hgnisnattart 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.In your case it is a measure filter problem but same concept. It's just you would have an extra filter in there like:
SUMX(
FILTER(
SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ),
[Measure] > <some threshold>
),
[Measure]
)
hgnisnattart 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.
In your case it is a measure filter problem but same concept. It's just you would have an extra filter in there like:
SUMX(
FILTER(
SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ),
[Measure] > <some threshold>
),
[Measure]
)
Thank you, Greg_Deckler! This worked perfectly.