Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summing Sub Groups for Measure

Hey All,   I have a report that contains groups, some of which have subgroups, and I need to calculate everything at the primary group level. The primary metric I'm having an issue with is the Exce...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous

This looks like a measure totals problem.See the post about it here:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

 

And I have used your formulas and my sample data do a test.

Measure = var _table=SUMMARIZE(dimGroup,dimGroup[Month Name],"a",[Active Months]) return
CALCULATE(SUMX(_table,[a]))


Measure 2 = var _table=SUMMARIZE(dimGroup,dimGroup[Month Name],"b",[Exceeding Goal]) return
CALCULATE(SUMX(_table,[b]))


Measure 3 = [Measure 2]/[Measure]

Result:

For measure total is 9+5=14

For measure 2 total is 7+2=9

For measure total is (7+2) / (9+5)=64% not 4 / 9=44%

 

If not your case, Please share sample pbix file or some data sample and expected output for us. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading

 

 

Best Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-lili6-msft that worked perfectly, I'll have to read up on the summarize function, really appreciate it!