How to calculate subcategory Weight over Category

[Anonymous]

Hello,
I have this dataset, and need to calculate the subcategory weight over the category (not over the total).

So that the sum of the subcategories gives me 100%

When I am in Category row, I want to show the Category weight over total amount (p.e. 47% in Category 1) and when I am in subcategory row, I want to show the subcategory weight over the category amount.
For example:

Thank u very much

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and tha attached pbix file.

It is for creating measures.

Percentage measure: =
VAR _categorytotal =
    CALCULATE ( [Value total:], ALL ( Category[Subcategory] ) )
VAR _alltotal =
    CALCULATE ( [Value total:], ALL () )
RETURN
    SWITCH (
        TRUE (),
        ISINSCOPE ( Category[Subcategory] ), DIVIDE ( [Value total:], _categorytotal ),
        ISINSCOPE ( Category[Category] ), DIVIDE ( _categorytotal, _alltotal ),
        DIVIDE ( _categorytotal, _alltotal )
    )