Summing Sub Groups for Measure

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