Count row with Or Condition and able to show 0

njxfoster — Wed, 15 Feb 2023 18:09:04 GMT

Hi everyone!

I want to create a measure that counts how many "Yes and "S" from this table, which should be 4, However, I also want the measure to able to show number "0" when there are no counts (instead if showing blank).

How should I write this measure?

Thanks in advance.

Re: Count row with Or Condition and able to show 0

tamerj1 — Wed, 15 Feb 2023 18:53:51 GMT

Hi njxfoster

please try

IF (

NOT ISEMPTY ( 'Table' ),
COUNTROWS (

FILTER (

'Table',

'Table'[Completion_Status__c] IN { "Yes", "S" }
)

) + 0

)

topic Re: Count row with Or Condition and able to show 0 in DAX Commands and Tips

Count row with Or Condition and able to show 0

Re: Count row with Or Condition and able to show 0