Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
marculos
Regular Visitor

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                               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" }
)

 

1 ACCEPTED SOLUTION
prateekraina
Memorable Member
Memorable Member

Hi @marculos,

 

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

 

    Capture.PNG

 

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

 

    

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



Regards,
Prateek Raina 

View solution in original post

3 REPLIES 3
prateekraina
Memorable Member
Memorable Member

Hi @marculos,

 

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

 

    Capture.PNG

 

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

 

    

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



Regards,
Prateek Raina 

works great for me thanks bud. 😄

Brilliant @prateekraina works great many thanks !!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.