topic Re: Percent usage in matrix type table in Power BI. in DAX Commands and Tips

Percent usage in matrix type table in Power BI.

Anonymous — Wed, 01 Mar 2023 17:52:55 GMT

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]

Re: Percent usage in matrix type table in Power BI.

andhiii079845 — Wed, 01 Mar 2023 18:33:13 GMT

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

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

Re: Percent usage in matrix type table in Power BI.

FreemanZ — Thu, 02 Mar 2023 02:35:56 GMT

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:

Re: Percent usage in matrix type table in Power BI.

Anonymous — Thu, 02 Mar 2023 10:32:06 GMT

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