How to get percentage from multiple different rows

[annika29]

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? 

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

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

[annika29]

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:

https://www.upload.ee/files/10390008/Test.xlsx.html

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

[v-diye-msft]

Hi @annika29 ,

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

[annika29 · Accepted solution]

• 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