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
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi euthor,

Could you please post some sample data to have a test and post your desired result if possible?

 

Regards,

Daniel He

  • euthor's avatar
    euthor
    Frequent Visitor
    7 years ago

    Hi all,

    here's the raw file format for the data (Excel):

     

    Time PeriodBrandLicenseSales
    Jan 01 2018 - Jan 07 2018Galaxy wireless Mouse (Contoso)Galaxy Wires150,00 €
    Jan 01 2018 - Jan 07 2018Contoso USB mouseNot Specified43,00 €
    Jan 01 2017 - Jan 07 2017Galaxy wireless Mouse (Contoso)Galaxy Wires150,00 €
    Jan 01 2017 - Jan 07 2017Contoso USB mouseNot Specified43,00 €
    Sep 29 2018 - Sep 04 2018Galaxy wireless Mouse (Contoso)Galaxy Wires170,00 €
    Sep 29 2018 - Sep 04 2018Contoso USB mouseNot Specified45,00 €
    Sep 29 2017- Sep 04 2017Galaxy wireless Mouse (Contoso)Galaxy Wires170,00 €
    Sep 29 2017- Sep 04 2017Contoso USB mouseNot Specified45,00 €

     

    Please note that:

    - the section with date is in text format (for PBIX file), and it cannot be converted it to data format as weel - already tried, PBIX cannot perform the operation;

    - both  brand and license data are reported as text, while the only number format is for Sales data.

    - I remind you that I cannot modify the format in any case.

     

    The desired result is to display a pie chart which shows how much the 'Not Specified' total sales for weight (in terms of percentage) compared to the total amount of the ficitional Licensed goods for 2018 --> in other terms, I have to display graphically the market share of both Licensed and non-licensed goods.

     

    Hope this would help you to figure out your solutions to my problem!

     

    Thank you.

    • v-danhe-msft's avatar
      v-danhe-msft
      Icon for Microsoft Employee rankMicrosoft 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!