cancel
Showing results for
Did you mean:
Frequent Visitor

## How to get percentage from multiple different rows

Hi

I have 4 different  column values that come from table. Each value must be Sum and percentage and last one total of them all

Below is example where 101 = sum(tablename.column2) is 100% and then 33 = sum(tablename.column3) is 32%, 23 is 22% and so on

With these values i need to make a graph. Do i need to write some kind of measure, where it would take 4 different sum values of  then change them to needed percentage or is there another way?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

## Re: How to get percentage from multiple different rows

• In Dispute vs CurrentAmount (%)
• In Collection vs CurrentAmount (%)
• VIPRecieivables vs CurrentAmount (%)
• Overdue vs CurrentAmount (%)

Hard to explain, but like before i said, CurrentAmount is Total

Edit. I found a solution to my problem. I used marketplace and installed custom gauge, that does the trick

4 REPLIES 4
Super User

## Re: How to get percentage from multiple different rows

Depends on what you want your graph to be, can you provide an example?

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Frequent Visitor

## Re: How to get percentage from multiple different rows

I dont really have a specific graph in mind. As long as it shows the right percentage. I tried with stacked column graph

Test file:

JanCurrentAmount is the total and current, totaloverdue, indispute, incollection are then part of it.

Community Support Team

## Re: How to get percentage from multiple different rows

Hi @annika29 ,

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

## Re: How to get percentage from multiple different rows

• In Dispute vs CurrentAmount (%)
• In Collection vs CurrentAmount (%)
• VIPRecieivables vs CurrentAmount (%)
• Overdue vs CurrentAmount (%)

Hard to explain, but like before i said, CurrentAmount is Total

Edit. I found a solution to my problem. I used marketplace and installed custom gauge, that does the trick

Announcements

#### Community Highlights

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

#### 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: 390 members 3,850 guests
Recent signins: