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
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
Guys,
I you understood and solved my challenge at the same time I feel stupid now though :D
Thanks
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