Filtering by Multiple Measures

[Anonymous]

Hi all.

I have several measures in my model which look like the below:

UnlimitedCount =

CALCULATE(

COUNT('Contract Item'[Account ID])

,

FILTER('Contract Item','Contract Item'[Package Category]="Unlimited"

))

***

CommercialCount =

CALCULATE(

COUNT('Contract Item'[Account ID])

,

FILTER('Contract Item','Contract Item'[Package Category]="Commercial"

))

What I'd like to do is set both of these as a filter, such that results are shown if either of them is greater than 1. 

Does anyone have any ideas of how to achieve this?

Thanks

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may just add an additional measure.

Measure 3 =
IF ( [Measure] > 1 || [Measure 2] > 1, 1 )

[Anonymous]

Simple and elegant, thanks @v-chuncz-msft!