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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi CiuCiCiao

 

Don't worry :smileyhappy: I'm going to be at the office in a couple of hour, and I will come up with something for you by then :)

Anonymous's avatar
Anonymous
Not applicable
9 years ago

CiuCiCiao

 

I would very much appreciate either a data set or the pbix. file. That will help me solve your problem 10x faster. Can you do that for me?