How to only add up True values in a column

[Anonymous]

Hello

I have a calculated column where it returns "true" if the budget column is below budget. I am trying to understand the % of projects (rows) that are under budget compared to the total amount of rows.

How do I add up only the "true" rows in a column, so that I can divide by the total number of rows? this would give me the % of projects under budget vs total projects.

I did this formula, but I don't believe it is accounting for only the "true" results

Count of On_UnderBudget divided by Count of Store Number =

DIVIDE(

                COUNTA('CML-Filtered'[On_UnderBudget]),

                COUNTA('CML-Filtered'[Key])

))

[Anonymous]

You can count the true/False using countrows.

CALCULATE(COUNTROWS(Table1),Table1[True_False_Col]=TRUE())

Thanks
Raj

[Anonymous · Accepted solution]

Hey,

give this a try it should do what you're after:

Count of On_UnderBudget divided by Count of Store Number = 

divide(

calculate(counta('CML-Filtered'[Key]),'CML-Filtered'[On_UnderBudget] ="true"),

calculate(counta('CML-Filtered'[Key]))

)