cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Percent of column Total

Hi! Could anyone show me how to show a percent of column total in my chart? I only have the choice % of grand total. I would like to show the percent of column total as in the matrix table (screen shot). Please? Best regards Michael

1 ACCEPTED SOLUTION
Employee

Hi @Micnorex,

If I understand you correctly, you should be able to use the formula below to create a new measure to calculate the percent of column total, and show the measure as Values on the Chart to get the expected result in your scenario.

```Measure =
DIVIDE (
COUNTA ( 'Sheet1'[Number] ),
CALCULATE ( COUNTA ( 'Sheet1'[Number] ), ALL ( 'Sheet1'[Alder] ) )
)
```

Regards

2 REPLIES 2
Employee

Hi @Micnorex,

If I understand you correctly, you should be able to use the formula below to create a new measure to calculate the percent of column total, and show the measure as Values on the Chart to get the expected result in your scenario.

```Measure =
DIVIDE (
COUNTA ( 'Sheet1'[Number] ),
CALCULATE ( COUNTA ( 'Sheet1'[Number] ), ALL ( 'Sheet1'[Alder] ) )
)
```

Regards

New Member

Thank you, that made the trick. Really appreciate it!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

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

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

Top Solution Authors
Top Kudoed Authors