powerbi - Create a Power BI measure that can handle in AND out of context values - Stack Overflow

I already worked a bit with Power BI, but I'm still kinda new using dax so I can't figure out

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.

发布者:admin,转转请注明出处:http://www.yc00.com/questions/1744076564a4554510.html

相关推荐

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信