Counting the number of occurences of a field

[Anonymous]

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.

[amitchandak]

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

[Anonymous]

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?

[amitchandak · Accepted solution]

Try

NumberHits = CALCULATE(COUNT(name[CP_ID]), name[WIN_FLAG]=TRUE())
NumberMisses = CALCULATE(COUNT(name[CP_ID]), name[WIN_FLAG]=FALSE())