Creating a measure.

[assistant_sense]

Hello. I need help creating a measure named percentage. The o/p should be as the column percentage. I have attatched a pic for your reference. I would really appreciate it if you could help me on this topic. ThanksI need to represent the data like a waterfall chart.

[v-tianyich-msft]

Hi @assistant_sense ,

I don't find O/P in the diagram, what does it mean and what is your data structure, can you provide more details? If it's just the example in the diagram, you can just use the divide function.

DIVIDE function (DAX) - DAX | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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