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

 

Did you try to add the condition: Time[Services]<>"Service 6" to your calculation?

 

=
RELATED ( FTE[Operating Cost] ) * Time[m]
    / CALCULATE (
        SUM ( Time[m] ),
        Time[Services]<>"Service 6",
        FILTER ( Time, Time[Office] = EARLIER ( Time[Office] ) )
    )

 

Or something like this?

 

Best,

Martin

CiuCiCiao's avatar
CiuCiCiao
Helper I
9 years ago

Hi aidval

Sure I tried, but gives back wrong results! I guess the problem is that I have to filter also the numerator but I can't find a proper way...

Any help?

Thanks

  • CiuCiCiao's avatar
    CiuCiCiao
    Helper I
    9 years ago

    up

    • 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?