Forum Discussion

CiuCiCiao's avatar
CiuCiCiao
Icon for Helper I rankHelper 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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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"))