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
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

Did I answer your question? Mark my post as a solution!

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.

Highlighted
Community Support Team

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

Hi @annika29 ,

we've got your file but not quite understand your requirement, could you please show me your logic and expected data?

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.
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

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

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

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

Top Kudoed Authors
Users Online
Currently online: 55 members 709 guests
Recent signins: