admin 管理员组

文章数量: 1086019

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.

本文标签： powerbiCreate a Power BI measure that can handle in AND out of context valuesStack Overflow

版权声明：本文标题：powerbi - Create a Power BI measure that can handle in AND out of context values - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://roclinux.cn/p/1744076565a2529460.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。