Forum Discussion

yosemite's avatar
yosemite
Helper III
6 years ago
Solved

Filter OUT Multiple Values

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.
Need Help
  • AlB's avatar
    AlB
    6 years ago

    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 

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    6 years ago

    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