Need help and or condition

[Anonymous]

i have a condition  to find  Unique ticket ID count  using this filter 

 Status equal to Match  and  Type equal to Invoice  or  Type equal to Certificate

When I tried the following, it did NOT work:

I'm Using Measure

Correct =

CALCULATE(DISTINCTCOUNT ('Finallist'[Ticketno]),

FILTER('Finallist',Finallist[Status]=="Match" && Finallist[Type]=="Invoice" || Finallist[Type]=="Certificate" && MONTH('Finallist'[Date])=MONTH(TODAY())-2)

)

[sturlaws · Accepted solution]

You are probably just missing the paranthesis to group your conditions together:

Correct =
CALCULATE (
    DISTINCTCOUNT ( 'Finallist'[Ticketno] ),
    FILTER (
        'Finallist',
        ( Finallist[Status] == "Match"
            && Finallist[Type] == "Invoice" )
            || (
                Finallist[Type]
                    == "Certificate"
                        && MONTH ( 'Finallist'[Date] )
                            = MONTH ( TODAY () ) - 2
            )
    )
)

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.