Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
Try
NumberHits = CALCULATE(COUNT(name[CP_ID]), name[WIN_FLAG]=TRUE()) NumberMisses = CALCULATE(COUNT(name[CP_ID]), name[WIN_FLAG]=FALSE())
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?
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |