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

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 125 members 1,717 guests
Recent signins: