Calculate % of total value of each category

[matpat1284]

Hi,

I've got a large dataset of volumes per each category, my table looks like this:

Date	Category	Volume
1.01.2023	A	1023
1.01.2023	B	421
1.01.2023	C	241
1.01.2023	D	144

I would like to build up a visual that shows % of each category per day vs the total sum of the volume. 

How to write a formula in Power BI to achieve this?

[matpat1284]

It doesn't work for me 🤔

[Padycosmos]

Could you please provide the Measure that you have used

[matpat1284]

Payments % = Divide (CALCULATE(SUM(FT[ORDERS_VOLUME])), CALCULATE (SUM(FT[ORDERS_VOLUME]), ALLSELECTED (FT)))

[Padycosmos]

Looks ok. Could you please increase decimals to 2 in the format of the measure?

[matpat1284]

it is ok, if you look at grand total, however, I would like to include the same for each day, so it seems like it does not count it for each day but only for the overall period

[Padycosmos]

If you want Sub totals for each day, you may try turning subtotals on in the formatting of the visual

[matpat1284]

I want to build it this way: 

However, with this formula it gives me inaccurate percentages. For each day each category should give 100% as a sum, whereas here it's showing % of all per selected period of time I guess

[Padycosmos]

If you could giveme the pbix file, I can explore

[Padycosmos]

Hope this helps:

[lkshck]

This one worked perfectly for me, thanks a lot! I've got another question on how to use the percentage values for further actions? So what I want to achieve is to keep this table and using another table containing a Sum of Costs and those costs should be spreaded based on the percentage values to the products from your example. Any chance to achieve this?

Thanks in advance!

[Padycosmos]

Hello,

You will have select the second table and create another measure , such as cost %, in that table. You may use the same formula by changing the column name to Cost .

Hope this helps