cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

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

1 ACCEPTED SOLUTION
Super User

try like:

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

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:

3 REPLIES 3
Super User

try like:

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

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:

Regular Visitor

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

Super User

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

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

Proud to be a Super User!

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors