Calculate % and Group by Value

[DAX_Noob82]

Hi All,

I have a table which contains mulitple columns. 2 of those columns are 'Pass/Fail' & 'AgeGroup' containing the following values as a sample:

PassFail	AgeGroup
Fail	26-34
Pass	18-35
Fail	26-34
Pass	36-50

How do I calculate the % to 100% of each age group in a 'Clustered Column Chart'?

I tried the following but it's not giving me a total of 100%:

%PassFail = VAR PassFailTotal = COUNT(Tablename[PassFail])

                   VAR AgeGroupTotal = CALCULATE(COUNT(Tablename[PassFail]), ALLEXCEPT(Tablename,SubjectHealth[AgeGroup]))

                   RETURN

            DIVIDE(PassFailTotal,

                      AgeGroupTotal)

Instead it give me this:

Thanks.

[ValtteriN · Accepted solution]

Hi, 

Try something like this:

Example data:

Dax:

Pass/ fail for group =

var _c=

CALCULATE(COUNT('Table (10)'[Pass/Fail]),ALL('Table (10)'[Pass/Fail]))

var __category = COUNT('Table (10)'[Pass/Fail])

return

DIVIDE(__category,_c)

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/