cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Filter OUT Multiple Values

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 

SU18_powerbi_badge

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Filter OUT Multiple Values

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 

SU18_powerbi_badge

View solution in original post

Highlighted
Helper II
Helper II

Re: Filter OUT Multiple Values

@AlB Thanks so much!

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors