cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shkabuzar Frequent Visitor
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

 

12323.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Percentages to multi line report

@shkabuzar,

 

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
Community Support Team

Re: Percentages to multi line report

@shkabuzar,

 

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.
shkabuzar Frequent Visitor
Frequent Visitor

Re: Percentages to multi line report

Thank you so much.