Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculate subtotal rows by column?

I have some data ('HSBY') which contains periods during which an application was unavailable. The data is formatted with a Date colum, a start time column, a duration and an endtime column and I add...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous 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
    3 years ago

    Thanks but I don;t think this will work - the 0s and 1s that I am formatting in my DAX measure and that are displayed inthe matric don't exists as values in a table, so I don't know if I can create a susb-total from them?

     

    I'm still quite new to DAX and Power Bi, so I may be looking at this incorrectly.