Percentage of category and subcategory agints a specific category

[Anonymous]

Hi;

I want to calculete a percentage of my category and subcategories against the total sum of one of my categories. Any idea?

Best regards

[remyacholayil]

@AnkitBI 

i have a similar issue where i ahev to calculate the precentage in a slightly different way.

e have a model build in power bi like this.Using this model i have to built a matric visual in power bi which has unit in the column and liquidity name,expense heading and expense header sub categories in the rows.The values should be sum of amount and GTN%.The challenging part is to create the Gross to Net percentage creation.The customer has asked us to show the GTN percentage for different expense heading as shown below. For example ,if the value for expense heading one is 2 and the total value for the liquidity type="income" is 900.The percentage has to calculated like 2/900 for each expense heading.Iam struggling to get this done.

Here the expense heading come from one dimension table called dim expense heading,liquidity comes from another table which has both income and expense liquidity, the unit comes from different dimensions.The fact has all the surrogate key for these dimensions.

I have created a DAX =calculate(sum(amount),dimliquidity="expense")/calculate(sum(amount),dimliquidity="INCOME").But this is not showing the percentage across all the expense heading rows.

	Unit1(dim unit)
	Amount	GTN%
liquidity(income)(dim-liquidity)	968
liquidity(expense)
expense1(dimexpense heaidng)	-28	0%
expense2	-45	-5%
expense3	-153	-16%
expense4	-12	-1%
expense5	-23	-2%
expense6	-14	-1%
expense7	-4	0%
expense8	-2	0%
expense9	-42	-4%
expense10	-40	-4%
expense11	0	0%
Total Expenditure	-364	-35%

This is showing only at the higher level.not at athe expense heading levels.

i want to populate percentage in all the rows aganist the  expense heading name corresponding to that.

Could anyone help meplease

[AnkitBI]

Can you define your requiement with a sample data.

[Anonymous]

I have this data and I want to calculte the percentage of each category and subcategory base on my Total Sales of Music category.

[AnkitBI · Accepted solution]

Try Below

Measure = DivIDE(SUM(Source[Value]),CALCULATE(sum(Source[Value]),filter(all(Source),Source[Category]= "Musica")))

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

[Anonymous]

It works perfectly. Thank you.