Divide/Calc Function

DAX DAX Calculations
1

I would like to divide the Sales Volume data from the top Matrix chart with the bottom Matrix chart to get Volume share etc on page 3. See pbixhttps://drive.google.com/file/d/186vsjbqclSXB4m5LGwdp3agMQ6-63LDs/view?usp=sharing

2

Hi @Yrstruly

Please give a try with below DAX if it works on your actual data as the sample data is not enough to visualize it.

BottomMatrix = SUM( Sheet1[Sum of Sales Volume] )

TopByBottom = 
CALCULATE(
    [BottomMatrix] , 
    USERELATIONSHIP( Sheet1[Brand], Sheet3[Brand] )
)

Thanks
Mukesh

3

Hi @Yrstruly, did the response provided by @MK3010 help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

I hope that you are having a great experience using the Support Forum so far. Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!

4

Hi @Yrstruly, we’ve noticed that no response has been received from you since the 11th of June. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

5

Hi @Yrstruly, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks.

6

Itdoes not work.