Show Percentage on Matrix but Category is 100

[Anonymous]

Is this possible in PowerBI. 

Can I have a Pivot matrix that has the following format?

Category A		100
	Sub category A.1	24
	Sub category A.2	76
Category B		100
	Sub Category B.1	23
	Sub Category B.2	77
Category C		100
	Sub Categoy C.1	22
	Sub Categoy c.2	78

This is called % of Parent Total in a pivot table in Excel:

This seems to work fine when working with a filter but not when you have the filter off:

For example: Filter Off:

We don't want the sum of each constituent to be the subtotal adding to the Category ...

But we want the sum as such on one Pivot Matrix for each category. Sort of like a union on a database query. 

Is it possible to have the above picture equal to each 100% without having to filter?

[v-diye-msft]

Hi @Anonymous 

Plz let me know if you'd like to get this one:

Measure = IF(NOT(ISINSCOPE('Table'[Department])),1,DIVIDE(SUM('Table'[Cost of Material]),SUMX(ALLEXCEPT('Table','Table'[Product]),[Cost of Material])))

[Anonymous]

The sum of the percentages are not adding correctly. You may have put the percentage sum correct but percentage of 'a' should be a percent of Total '1'.

[amitchandak]

@Anonymous , refer if this can help

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390