Forum Discussion
Exclude only one value from filtering
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
Dear Greg_Deckler Anonymous
I am back on my problem...
Now I have gone forward, I have the Operating Cost:
| FTE | ||||
| Office | Potential Hours | Effective Hours Worked | Operating Cost | Non Operating Cost |
| Office 1 | 1.200 | 1.000 | 9.400 | 10.000 |
| Office 2 | 1.500 | 1.300 | 9.800 | 7.900 |
| Office 3 | 2.500 | 2.000 | 22.000 | 2.900 |
I have to bring them back to the other table:
| Time | ||||
| Services | m | Office | Operating Cost | Non Operating Cost |
| Service 1 | 206 | Office 3 | ? | ? |
| Service 2 | 932 | Office 1 | … | … |
| Service 3 | 510 | Office 2 | … | … |
| Service 4 | 331 | Office 1 | … | … |
| Service 5 | 23 | Office 2 | … | … |
| Service 6 | 1.225 | Office 1 | 0 | 0 |
| Service 7 | 39 | Office 3 | … | … |
| … | … | … | … | … |
I have excluded before Service 6 from my calculation, but when bringing it back to the Time table, using the following formula, it will redistribuite also for Service 6.
=
RELATED ( FTE[Operating Cost] ) * Time[m]
/ CALCULATE (
SUM ( Time[m] ),
FILTER ( Time, Time[Office] = EARLIER ( Time[Office] ) )
)
I tried different ways but non of them worked out...
Any help?
Thanks
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
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