Filter

[Moniek]

Hi, I have a table and I want to calculate a % of a value, example, I want % of the total " Omzet" . In my case "Omzet" is 600 = 100%, I want to make a meassure, "Bedrag / Omzet * 100%". There is somtething to do with filter but I don't find the right one yet. Example, "Belastingen" = -400 / 600 = -66,66% instead of 0,00%. Thanks!!

[NickolajJessen]

Does this work?

[stefani_vileva]

Hello,

You can just create a measure:

Measure = DIVIDE(SUM(Bedrag), SUM(Omzet))

and then just convert this to % and thats it.

I hope this solves your problem.

Kind regards,

Stefani

[Moniek]

@stefani_vileva Thanks but unfortunately that's not the right measure, because "Bedrag" and "Omzet" are already measures.

[stefani_vileva]

Can you try with simply using Divide([Bedrag], [Omzet]) ? Or if this is not working, please share your file.

[Moniek]

@stefani_vileva how do I share the pbix?

[stefani_vileva]

Upload it to a drive or somewhere and send a link.