Filter OUT Multiple Values

[yosemite]

Hello - Here's the link to my original post. 

I have to filter out two values in the Measure. The values are "RDO" and "Weekend".  How do I update the measure below to filter out two values?

Measure =

CALCULATE (

COUNT( 'Table'[Value] ),

FILTER( 'Table','Table'[Value]<>"RDO" ) ) / CALCULATE(COUNT('Table'[Value]), FILTER(ALLEXCEPT('Table'[EmployeeName],'Table'[EmployeeNo],'Table'[Weekof]),'Table'[Value]<>"RDO"))

Thank you.

[yosemite]

I have to filter out two values in the Measure. The values are "RDO" and "Weekend".  How do I update the measure below to filter out two values?

Measure =

CALCULATE (

COUNT( 'Table'[Value] ),

FILTER( 'Table','Table'[Value]<>"RDO" ) ) / CALCULATE(COUNT('Table'[Value]), FILTER(ALLEXCEPT('Table'[EmployeeName],'Table'[EmployeeNo],'Table'[Weekof]),'Table'[Value]<>"RDO"))

Thank you.

[AlB · Accepted solution]

Hi @yosemite 

FILTER( 'Table','Table'[Value]<>"RDO"  && 'Table'[Value]<>"Weekend" )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[yosemite]

@AlB Thanks so much!