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

[njxfoster]

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" ) ) ),

        0,

        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!

[tamerj1]

Hi @njxfoster 

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

[Wilson_ · Accepted solution]

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?)