cancel
Showing results for
Did you mean:
Frequent Visitor

## Percentages to multi line report

Hi,

Here is the report which showing values, I would like to calculate percentages of it.

ex: for Nov 2018 A = 32 , B = 24

Expected results A=57.14%, B= 42.85%

Please let me know how to solve this.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team

## Re: Percentages to multi line report

You may use measure below.

```Measure =
DIVIDE (
SUM ( Table1[Count] ),
CALCULATE ( SUM ( Table1[Count] ), ALLSELECTED ( Table1[Category] ) )
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
Community Support Team

## Re: Percentages to multi line report

You may use measure below.

```Measure =
DIVIDE (
SUM ( Table1[Count] ),
CALCULATE ( SUM ( Table1[Count] ), ALLSELECTED ( Table1[Category] ) )
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

## Re: Percentages to multi line report

Thank you so much.