Forum Discussion
Helper IMeasure based on dividing on types
or try this
Helper IYou are 100% right Ahmedx, but you can also say:
If VXO = 70 and NXO is not present -> 70
If VXO is not present and NXO = 70 -> 70
If VXO = 70 and NXO = 70 -> 70
or
If VXO = 10000 and NXO is not present -> 10000
If VXO is not present and NXO = 10000 -> 10000
If VXO = 10000 and NXO = 10000 -> 10000
So in general I just wanted to state that if on ONE 'Costcenter'[Number] you have ánd NXO ánd VXO the amount must be divided by 2. And if only NXO ór VXO is present then you need that number.
But the outcome of your query looks ok, but I can't imagine that that 80 is necessary.
I hope I'm more clear now!?
Super UserI get it, you can just write it like that
- Ahmedx
or try this
- MikeHendriks
So close Ahmedx.... I really appreciate your help!
But filtering on 'number' gives issues. Do you have an idea for this as well:
- Ahmedx
try again
- MikeHendriks
Amazing Ahmedx. Thank you very much!