topic How can I add one more filter condition for this measure? in DAX Commands and Tips

How can I add one more filter condition for this measure?

njxfoster — Thu, 18 May 2023 21:57:27 GMT

Hi Guys

I am using this measure to count every rows contained "I", and if there are no "I", I want to count it as 0 instead of blank

IT = IF (

NOT ISBLANK ( COUNTROWS ( 'Roster' ) ),

IF (

ISBLANK ( COUNTROWS ( FILTER ( 'Roster', 'Roster'[Completion_Status] = "I" ) ) ),

COUNTROWS ( FILTER ( 'Roster', 'Roster'[Completion_Status] = "I" ) )

)

Now I need to count the row with "IT" as well, What should the measure be?

Thanks in advance!

Re: How can I add one more filter condition for this measure?

Wilson_ — Fri, 19 May 2023 00:09:57 GMT

Hello njxfoster,

If I've understood your question correctly, try replacing "FILTER ( 'Roster', 'Roster'[Completion_Status] = "I" )" with "FILTER ( 'Roster', 'Roster'[Completion_Status] IN { "I", "IT" } )".

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

Re: How can I add one more filter condition for this measure?

tamerj1 — Sat, 20 May 2023 05:13:03 GMT

Hi njxfoster

how does your visual look like? What columns are placed in the visual? How does your data model look like?