Forum Discussion

coffjoh2004's avatar
coffjoh2004
Regular Visitor
3 years ago
Solved

Overlapping filters

Hello, I am writing a measure that needs to exclude certain outage codes, but those outage codes i want excluded need to be used in another part of the same visual, so i'm having troubles with the o...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  coffjoh2004 ,

     

    Here are the steps you can follow：

    1. Create measure.

    Future WO's1 =
CALCULATE(count(WORKORDER[WONUM]),filter('Outage Code Bridge',
NOT('Outage Code Bridge'[Outage Code]) in {"A2111","A2221","A2241"}))
    Future WO's2 = CALCULATE(count(WORKORDER[WONUM]), filter('Outage Code Bridge', 'Outage Code Bridge'[Outage Code]<>"A2111"&&'Outage Code Bridge'[Outage Code]<>"A2221"&&'Outage Code Bridge'[Outage Code]<>"A2241"))

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  coffjoh2004 ,

 

Here are the steps you can follow：

1. Create measure.

Future WO's1 =
CALCULATE(count(WORKORDER[WONUM]),filter('Outage Code Bridge',
NOT('Outage Code Bridge'[Outage Code]) in {"A2111","A2221","A2241"}))
Future WO's2 = CALCULATE(count(WORKORDER[WONUM]), filter('Outage Code Bridge', 'Outage Code Bridge'[Outage Code]<>"A2111"&&'Outage Code Bridge'[Outage Code]<>"A2221"&&'Outage Code Bridge'[Outage Code]<>"A2241"))

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly