Forum Discussion

euthor's avatar
euthor
Frequent Visitor
7 years ago

market share calculation issues

Hi all, I am struggling with DAX measurements, so I need your help even to solve easy things.   I want to calculate how much both "Brand" and "License" amounts weight on the total sales for Y2018,...
Need Help
Show and Tell
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi euthor,

Based on my test, you could refer to below steps:

Create a calculated column in your row table:

2018Sales = IF(RIGHT('Table1'[Time Period],4)="2018",'Table1'[Sales],BLANK())

Create a pie chart and set the value as percent of grand of total:

You could also download the pbix file to have a view.

 

Regards,

Daniel He

euthor's avatar
euthor
Frequent Visitor
7 years ago

Hi Daniel He,

Thank you for your contribution!!

 

Your solution is correct (and great!) if I want to show the weight for the single variable, so I can calculate them one at a time for Brand and License. However my issue is to combine them, so that one pie chart shows the total for Y2018 soplit by License and Brand.

 

I hope that I have been clear enough for you to help me out with this!

 

 

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi euthor,

    Could you please post your desired result picture if possible?

     

    Regards,

    Daniel He

    • euthor's avatar
      euthor
      Frequent Visitor
      7 years ago

      How can I upload here a sample file so you can better understand what my goal is?

      • v-danhe-msft's avatar
        v-danhe-msft
        Microsoft Employee
        7 years ago

        Hi euthor,

        You could upload your report to your OneDrive or Dropbox and send the link to me.

         

        Regards,

        Daniel He