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 calculation

 

 

Thank you

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)

3 Replies

  • tchristy99's avatar
    tchristy99
    Helper II
    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