Establishing a MarginBridgeAnalyser

[HenrikStrand]

I am developing a margin bridge analyser, as I have done this succesfully in excel. I have several measures that I use like the price variance, but when it comes to the price efffect which is basically the sumproduct (as I would use in excel) of column quantity_baseperiod and price variance (defined in measure as AveragePrice Analysis Period - AveragePrice Base Period   ....per item). I ahve researched and the proposal is to use sumx function in dax but this is not very happy about using measures in the calculation...

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[HenrikStrand]

https://www.dropbox.com/scl/fi/eiagq3ks1lqh2hi60qm6v/VPM-TestData.pbix?rlkey=ei0xt0dip0kafvkeche5968...

[HenrikStrand]

https://www.dropbox.com/scl/fi/sr02kna9119d3wyz7mx3h/Fake-Data.xlsx?rlkey=ow6coelu084bvs48tvrx3zpj3&...

[HenrikStrand]

Attached were the pbix file and the excel export w calculations, so you can get an idea of my end game. Appreciate any help!

[v-zhangti]

Hi, @HenrikStrand 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.