Forum Discussion

CiuCiCiao's avatar
CiuCiCiao
Helper I
9 years ago
Solved

Exclude only one value from filtering

Hi Guys, I have 2 linked tables. the first has the time in minutes spent for the FTEs for all the services provided: Time Services m Office Service 1                              206 ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    You could always add a condition to your calculations which could be: Time[Services]<>"Service 6"

     

    This sets a condition for your calculation, which makes sure it always excludes service 6.

     

    If I misunderstand your challenge, please let me know and elaborate.

     

    Best,

    Martin

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

If you first measure is called "EffectiveHoursWorked" you could filter out Service 6 like this:

 

No6EffectiveHoursWorked = CALCULATE([EffectiveHoursWworked],FILTER(Time,[Services]<>"Service 6"))