Advanced Editor: if...then count...

[Misha]

Hi Forum,

I have this situation and i can't get the right result: I want to add an additional column where the value is the sum of some values a condition is fullfilled, if not it should be empty. Attached the situation I mean.

It would be great if someone could help me so thx in advance! Kind regards

[mwegener]

Hi @Misha 

is your problem solved?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Misha]

Excuse me for the delay. I do not want to be impolite and a quick screening gave me the impression the provided solution is satisfying but I haven’t found the time yet to investigate that thouroughly. You may be sure I 'll answer that in a short term!

Thanks fort he reminder

[dax]

Hi @Misha , 

You could refer to @mwegener 'susggestions. If this is not what you want, could you please inform me your logic of below image,

and inform me more detailed information (such as your sample data and your expected output), then I will help you more correctly.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @Misha ,

check this out.

PBIX

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.