最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

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

programmeradmin1浏览0评论

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.

发布评论

评论列表(0)

  1. 暂无评论