COUNTROW with OR/AND in filter measure

[Pbiuserr]

Hello,

I've got a measure which calculate in a wrong way. I believe its not hard for advanced pbi users, but the little description of how to handle that for the future would be benefitial for me 

Try to calculate every row which has RESOLVED collumn filled and is from Category1 + Category2.
I've break down this measure into two pieces to let it be easier to understood and here they are

Cat1 = CALCULATE(

Countrows(

filter(

'data', 'data'[RESOLVED] <> blank()

&& 'data'[CATEGORIES]="CAT1"

) ) ) - gives 1 (good)

Cat2 = CALCULATE(

Countrows(

filter(

'data', 'data'[RESOLVED] <> blank()

&& 'data'[CATEGORIES]="CAT2"

) ) ) - gives 14 (good)

however, when I try to combine them

CatTot = CALCULATE(

Countrows(

filter(

'data', 'data'[RESOLVED] <> blank()

&& 'data'[CATEGORIES]="CAT1" || 'data'[CATEGORIES]="CAT2"

) ) ) - gives bad result (suppose to be 15). Ignores BLANK

however:

CatTot = CALCULATE(

Countrows(

filter(

'data', 'data'[RESOLVED] <> blank()

&& 'data'[CATEGORIES]="CAT2" || 'data'[CATEGORIES]="CAT1"

) ) ) - gives good result, surprisingly - because when I reverse categories then I got bad results

Any ideas, tips?

Thank you in advance

[DataInsights]

@Pbiuserr,

The OR clause (||) needs to be enclosed in parentheses. Or, you can write it this way:

CatTot =
CALCULATE (
    COUNTROWS (
        FILTER (
            'data',
            'data'[RESOLVED] <> BLANK ()
                && 'data'[CATEGORIES] IN { "CAT1", "CAT2" }
        )
    )
)

[Pbiuserr]

Thanks. It works now. I'll later accept this as solution. Can you perhaps help me in this query

blogunder15-30 = CALCULATE(

COUNTROWS('data'),

    FILTER ('data',
                        NOT('data'[CATEGORIES] IN { "CAT", "CAT2" })
                         && 'data'[blogdays] >= 15 && 'data'[blogdays] < 30
       )

)

it counts wrong. above 14 days as well. where is an issue?

[DataInsights · Accepted solution]

@Pbiuserr,

You need to include all the filter expressions in the NOT clause:

blogunder15-30 =
CALCULATE (
    COUNTROWS ( 'data' ),
    FILTER (
        'data',
        NOT ( 'data'[CATEGORIES]
            IN { "CAT", "CAT2" }
            && 'data'[blogdays] >= 15
            && 'data'[blogdays] < 30 )
    )
)

Try to simplify:

blogunder15-30 =
CALCULATE (
    COUNTROWS ( 'data' ),
    FILTER (
        'data',
        NOT ( 'data'[CATEGORIES] IN { "CAT", "CAT2" } )
            && 'data'[blogdays] < 15
    )
)