Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count on Boolean

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 calculati...
Need Help
  • tchristy99's avatar
    tchristy99
    5 years ago

    Hi,

     

    Give this measure a try!

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
tchristy99
Helper II
5 years ago

Oh I see. Change the && to ||