topic Re: Filter OUT Multiple Values in DAX Commands and Tips

Filter OUT Multiple Values

yosemite — Thu, 04 Jun 2020 21:35:01 GMT

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.

Re: Filter OUT Multiple Values

AlB — Thu, 04 Jun 2020 22:01:18 GMT

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

Re: Filter OUT Multiple Values

yosemite — Thu, 04 Jun 2020 22:09:18 GMT

AlB Thanks so much!