Calculate percentage of each store as per total sales

[sneha_rudra]

Hi,

I have the following tables:

1) Dispatch data: It has Store name, sales, orders

  and I created a measure Total sales = sum(Sales)

2)Stores data: It has Store name and other information about stores

The 2 tables are joined by Store name column.

Now, I want to show the percentage of sale amount of each store , how can I calculate it?

For e.g.,

Store name     Total Sale      %of sales

Store 1            1000                 25%   

Store2             3000                 75%

So, I want the "%of slaes" column to be calculated. I am new to Power BI, please help! Thanks in advance..

[Najibe]

I have two tables in Power BI:
The first table of sales invoices has the sales invoice code and the total amount of each sales invoice, and the second table has the product code and the sales price of each product separately. I want to get the percentage share of each product separately from the total sales amount. A sales invoice may contain one or more products.
Thank


Table 1

sales invoice code	total amount
100	200
103	4500

Table 2 

product code	sales price
1	100
2	100
3	4500

[sneha_rudra]

Hi v-janeyg-msft,

Thank you so much, it's working perfectly fine. I just took the column total of the measure. 🙂

[v-janeyg-msft · Accepted solution]

Hi, @sneha_rudra 

According to your description, I think you can create a measure just like this:

Measure = var total=SUM(Table1[Sales])
var totalall=SUMX(ALL(Table1),[Sales])
return DIVIDE(total,totalall)

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey