Hi guys,

So i have this situation where i have a data model in Excel in which i would like to obtain Weight % with a DAX formula.

I've attached an example below. I want to achieve the second output ( Weight with Filter Context ) meaning that the DAX formula should act like a Show Values as % of Parent Row Total.

Country City Sales Weight w/o Filter Context Weight w Filter Context
Germany Munchen 50 11.6% 33%
Germany Berlin 100 23.3% 67%
France Paris 100 23.3% 36%
France Lyon 180 41.9% 64%

Can you tell me please how can i achieve this, without using the Show Values as % of Parent Row Total option from Pivot Table in Excel and instead create a DAX Formula ?

Thank you very much,
Best regards,
Bogdan