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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Counting the number of occurences of a field

Hi Everyone,

 

I would really appreciate anyones help with my situation.

 

Below is a table im working on

 

I am trying to count how many 'trues' and 'falses' there are for each CP_ID. I then want to find the percentage of 'trues' from the total of both 'trues' and 'falses'. 

 

I have tried this but get an error explaining I cant count boolean values.

 

NumberHits = CALCULATE(COUNT(name[WIN_FLAG]), name[WIN_FLAG]=TRUE(),ALL(name[WIN_FLAG]))
 
Any help would be appreciated.

 

 

bi help.png

1 ACCEPTED SOLUTION

Try

 

NumberHits = CALCULATE(COUNT(name[CP_ID]), name[WIN_FLAG]=TRUE())
NumberMisses = CALCULATE(COUNT(name[CP_ID]), name[WIN_FLAG]=FALSE())
Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

You can count CP_ID if both do not have any null values (nonoverlapping).

 

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Good idea, Counting the CP will give me the total of both true and false. How can I then split this and find the number for each true and false?

Try

 

NumberHits = CALCULATE(COUNT(name[CP_ID]), name[WIN_FLAG]=TRUE())
NumberMisses = CALCULATE(COUNT(name[CP_ID]), name[WIN_FLAG]=FALSE())
Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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