Count of True / False

[marculos]

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                               True

a                               True

a                               True

b                               True

b                               True

c                                True

d                                True

I want number of Trues to be 4 not 7. Any ideas on how to achieve this ? Appreciate any help !

Have tried

DistinctAcquiredCount = COUNTROWS(FILTER('tblZerion_C2', tblZerion_C2[acquired_status]='True'))

and

CALCULATE(
COUNTA('tblZerion_C2'[acquired_status]),
'tblZerion_C2'[acquired_status] IN { "True" }
)

[prateekraina · Accepted solution]

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]

works great for me thanks bud. 😄

[marculos]

Brilliant @prateekraina works great many thanks !!