I already worked a bit with Power BI, but I'm still kinda new using dax so I can't figure out how to do what I want to.
I have a table that look like this :
And I want to create a measure to calculate the %_valorisation column, I already manage to do it using visual calculation, but I want it to be a measure. The problem is that when I'm using a Dax formula like that :
Total valorisation = CALCULATE ( SUMX ( ZSTOCK12G, [Valorisation) ,all( ZSTJ1 [Article] ))
I should have the same value no matter the Article, so in my case "80" for Article : A, B, C. Because "80" is the total of valorisation. But I get the valorisation for each Article :
So of course when I use this "Total valorisation" to calculate my %_valorisation, this doesn't work and I get a column of "1".
How can I resolve my problem ? Considering that the "Percent of grand total" is not a solution for me, I need a measure that can be used in others visuals.