Percent usage in matrix type table in Power BI.

[Anonymous]

I am in doubt as to how to perform percentages when I go to the next level of drill down in my matrix, the first line was ok, but when I go down the level, 100% is displayed in all data.

My base formula is: 

Total Sales Underline = CALCULATE([Sale Qty Weight KG], ALLSELECTED('Item'[Underline - Name]))

% Share Underlines = DIVIDE([Sales Qty Weight KG], [Total Sales Underlines])

but there are other levels that need the percentage. Can someone help me?

how I use the other lines, like:

Item [Group - Name]
Item - Description [Description]

[FreemanZ · Accepted solution]

hi @Anonymous 

try like:

% Share Underlines = 
DIVIDE(
    [Sales Qty Weight KG], 
    CALCULATE(
        [Sale Qty Weight KG], 
        ALLSELECTED('Item'[Description])
)

Tried to simulate your case. Supposing your table looks like:

then try to plot the matrix with a measure like:

%Share = 
DIVIDE(
    SUM(TableName[Qty]), 
    CALCULATE(
        SUM(TableName[Qty]), 
        ALLSELECTED(TableName[Description])
    )
)

it worked like:

[Anonymous]

Good morning,

It worked, thank you very much!

In this case, I used the formula as:

% Participation Underlines = DIVIDE(
    [Sale Qty Weight KG],
     CALCULATE([Sale Qty Weight KG],
     ALLSELECTED('Item - Description'[Item - Description]), ALLSELECTED('Item'[Group - Name]), ALLSELECTED('Item'[Underline - Name])
))

[andhiii079845]

What happended when you add Item [Group - Name]
Item - Description [Description]  in the this statement? Like;

ALLSELECTED('Item'[Underline - Name],Item [Group - Name])