topic Re: Measure: Count of X, if Y=true in DAX Commands and Tips

Measure: Count of X, if Y=true

ARoma — Fri, 02 Dec 2022 19:17:15 GMT

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

Re: Measure: Count of X, if Y=true

djurecic — Fri, 02 Dec 2022 21:19:06 GMT

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!

Re: Measure: Count of X, if Y=true

ARoma — Mon, 05 Dec 2022 14:04:35 GMT

Hi @djurecicK2

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

Re: Measure: Count of X, if Y=true

djurecic — Mon, 05 Dec 2022 14:15:49 GMT

Hi ARoma ,

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

Re: Measure: Count of X, if Y=true

ARoma — Mon, 05 Dec 2022 16:04:36 GMT

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.

Re: Measure: Count of X, if Y=true

FreemanZ — Tue, 06 Dec 2022 07:03:59 GMT

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:

Re: Measure: Count of X, if Y=true

ARoma — Tue, 06 Dec 2022 14:27:14 GMT

Hi @FreemanZ , this is perfect!

Thanks a lot !