How to display percentage rows correctly after aggregation

[Sophie0320]

Hello All,

I have a table like this:

Q1_, Q2_, ..., and Annual Total are measures. The row % Completed was columns added previously in the Query Editor as [Staffing Achieved]/[Planned Staffing]. When I choose all ResourceCetegories,  it sums up the values, which is wrong. How to correct it? Same for the last row % Name Identified.

Thanks in advance!

[FreemanZ]

hi @Sophie0320 

Because A/B+C/D is not (A+C)/(B+D).

Or?

[Sophie0320]

I am a DAX newbie. Guess the measure expression needs some modifications to conditional assign the value. How?

[Sophie0320]

Hi FreemanZ, you are right. I want (A+C)/(B+D) after aggregation for those two % columns. Q1_, for example, the % Completed value should be 2/2, 100% at the end.

Here is the data for each category.

[Sophie0320 · Accepted solution]

Resolved. The table looks like this after updating the Q1_ measure's expression: