Row total, not percent not total

[ghartge]

Hey everyone,

I am at a loss here and need help. This seems like it should be something very easy to, and it probably is, but I am completely missing it.

I simply need to add a calculation that takes the "Failed" value and divides it by the "Passed" value in the attached document for each semester (fall and spring) down the column. In other words each row should have a percent for each year and semester. 

I have a field in the attached document titled "Calculated Item 2" which is where this calculated value should go and appear to the end user. I have several years across the top with semesters under those.

Thanks everyone, very frustrated here.

Gary

[PetriRoine · Accepted solution]

Hello @ghartge ,

You need to use Aggregated Measure. Please try this: 

Sum [_ByGroup_] ('Failed'n) / Sum [_ByGroup_] ('Passed'n)

Below is a picture showing the difference between using simple calculated measure Failed / Passed and aggregated measure Sum ByGroup Failed / Sum ByGroup Passed.

I hope this helps!

Best regards,

Petri

[ghartge]

Thank you PetriRoine!

I swear I tried that and it produced very odd values, but I obviously did something incorrectly. Thank you for the clarity.

Regards,

Gary