Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need help with finding the minimum value for a measure

I am trying to find the minimum value for my Measure 3 which is addition of two other measures. Measure 1 and 2. I am using this formula for the minimum value: MINX(Table,Measure3) The data granular...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello, 

     

    Appreciate the help. However, this did not work for me. My issue is that the date slicer filters out some products. I want minimum value of those products too.