topic Re: Get the grand total of the measures in DAX Commands and Tips

Get the grand total of the measures

Anonymous — Thu, 13 Apr 2023 16:20:18 GMT

I have a table like this, how can I get the grand total of these measures 'Distinct years', and 'check_distintct' ?

Re: Get the grand total of the measures

Anonymous — Thu, 13 Apr 2023 16:21:29 GMT

Just to be clear, I need another measure where the total of distinct year is 3 and check_distinct is 1 as shown in the total

Re: Get the grand total of the measures

Greg_Deckler — Thu, 13 Apr 2023 16:28:31 GMT

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.