Measure: Count of X, if Y=true

[ARoma]

Hi , I'm looking for a Measure in PBI that will allow me to get the Count of Injury, if Forseeble is True, from below table.

Incident number	Forseeble	Injury	Count of Injury if Forseeble True
1	TRUE	TRUE
2	FALSE	FALSE
3	FALSE	FALSE
4	FALSE	TRUE
5	TRUE	FALSE
6	TRUE	TRUE
7	FALSE	TRUE
8	FALSE	FALSE
9	FALSE	FALSE

[FreemanZ · Accepted solution]

Hi @ARoma 

try to create a measure with this:

ForeseeableInjuryCount =

CALCULATE(

    COUNTROWS(TableName),

    TableName[Forseeable]=TRUE,

    TableName[Injury]=TRUE

)

i tried and it worked like this:

[djurecicK2]

Hi @ARoma

 You can try something like this

Count of Foreseeable= CALCULATE(COUNT(Tablename[incident number]),FILTER(tablename, tablename[ForeseeableInjury]= true()))

Use "true" if that field is text. Please adapt to your field and table names.

Please accept as solution if this answers the question- thanks!

[ARoma]

Hi @djurecicK2

thanks for looking into this. I'm looking for the Count of Injury True, (not incidents), where Forseeble is also True.

[djurecicK2]

Hi @ARoma ,

 Have you tried that measure? If so, what were the results?

[ARoma]

Hi @djurecicK2

thanks for looking into this. I'm looking for the Count of Injury True, (not all incidents), where Forseeble is also True. If I undersend corectly , the measure you mentioned above is caluculationg all incidents where Forseable is True. 

[FreemanZ · Accepted solution]

Hi @ARoma 

try to create a measure with this:

ForeseeableInjuryCount =

CALCULATE(

    COUNTROWS(TableName),

    TableName[Forseeable]=TRUE,

    TableName[Injury]=TRUE

)

i tried and it worked like this:

[ARoma · Accepted solution]

Hi @FreemanZ , this is perfect!

Thanks a lot !