Measure based on dividing on types

you wrote the condition, If VXO = 80 and NXO is not present -> 80
I understand that if the conditions are met, the result should be 80

You 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!?

I get it, you can just write it like that

So close Ahmedx.... I really appreciate your help!

But filtering on 'number' gives issues. Do you have an idea for this as well:

try again

Amazing Ahmedx. Thank you very much!