Forum Discussion

marculos's avatar
marculos
Regular Visitor
8 years ago
Solved

Count of True / False

Hi,    I am struggling trying to get count of true/false to work. I have tried several different methods.    So I have e.g   User                          Acquired a                           ...
  • prateekraina's avatar
    prateekraina
    8 years ago

    Hi marculos,

     

    1. First make sure the data type of Acquired column is set to Text

     

        

     

    2. Use the below measure to get the desired result.

     

        

    Measure =
CALCULATE (
    DISTINCTCOUNT ( Table1[User] ),
    FILTER (
        Table1,
        Table1[Acquired] = "True"
    )
)



    Regards,
    Prateek Raina 

prateekraina's avatar
prateekraina
Icon for Memorable Member rankMemorable Member
8 years ago

Hi marculos,

 

1. First make sure the data type of Acquired column is set to Text

 

    

 

2. Use the below measure to get the desired result.

 

    

Measure =
CALCULATE (
    DISTINCTCOUNT ( Table1[User] ),
    FILTER (
        Table1,
        Table1[Acquired] = "True"
    )
)



Regards,
Prateek Raina 

Netjacker65's avatar
Netjacker65
Frequent Visitor
5 years ago

works great for me thanks bud. 😄