cancel
Showing results for
Did you mean:
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

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

#### PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 43 members 1,023 guests
Recent signins: