Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Percent usage in matrix type table in Power BI.

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 ...
@Dax
@divide
@microsoft
@powerbi
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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:

     

     

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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])
))