cancel
Showing results for
Did you mean:
Highlighted
Member

## Clustered Bar Chart - Percent of category/legend

How to find percent in clustered bar chart by axis/legend...any idea?? i have show in matrix..i want that to be in clustered chart!!any idea???

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Clustered Bar Chart - Percent of category/legend

Hi @Gokul,

I would suggest you use a measure instead.

```Measure =
DIVIDE (
COUNT ( Table1[id] ),
CALCULATE ( COUNT ( Table1[id] ), ALLEXCEPT ( Table1, Table1[dept] ) ),
99999
)
```

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super Contributor

## Re: Clustered Bar Chart - Percent of category/legend

Hi @Gokul,

I would suggest you use a measure instead.

```Measure =
DIVIDE (
COUNT ( Table1[id] ),
CALCULATE ( COUNT ( Table1[id] ), ALLEXCEPT ( Table1, Table1[dept] ) ),
99999
)
```

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: Clustered Bar Chart - Percent of category/legend

what does 9999 denotes??

Super Contributor

## Re: Clustered Bar Chart - Percent of category/legend

Hi @Gokul,

That's the alternative value in case of the failure of the calculation. You will know something is wrong when you get 99999. You can change it or ignore it like below.

```Measure =
DIVIDE (
COUNT ( Table1[id] ),
CALCULATE ( COUNT ( Table1[id] ), ALLEXCEPT ( Table1, Table1[dept] ) )
)
```

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 276 members 2,999 guests
Recent signins: