Count on Boolean

[Anonymous]

Hi,

I have 2 columns which are both booleans. I want to add the total count of true on the first column with the total count of true on the second column.

I would need help with the calculation

Thank you

[tchristy99 · Accepted solution]

Hi,

Give this measure a try!

Measure Name = CALCULATE(COUNTROWS(tableName), tableName[Yes-we-Canada] = TRUE && tableName[otherColumnName] = TRUE)

[Anonymous]

Hi @tchristy99 

I recieve a blank column.

Let me explain again.:

Lets say the total count (unfiltered) is 100. First, you apply a True filter on column A and the total count is 60. you then clear the filter and apply the same filter on column B and you get a total count of 56.

Is it possible to add 60 with 56? and if possible, how do i apply the calculation?

Thank you

[tchristy99]

Oh I see. Change the && to ||