Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dinesharivalaga
Helper IV
Helper IV

Percentage Calculation by dividing 2 values and grouping Age bucket

Hi All / @johnmelbourne 🙂

 

Again need some quick answer from you guys for below scenario :

Y axis : overdue amount 

X axis : Age bucket

Having Card as Total Overdue amount as per attached image .

 

Here i need to find percentage value for each bars (example 65.7M/133.35M , answer will be : 0.492 for 1st bar , like same , by age bucket each bar will be dividing by total overdue amount )

This chart only for NOV month and i have a slicer to change month wise data , so total overdue amout will change as per Month . So cannot hard code the value .

 

% find.jpg

 

 

 

 

 

 

 

 

 

 

 

 

Please help to fix this too ...

TIA

1 ACCEPTED SOLUTION

I think your issues is the visual is doing calculations like
65.7M / 65.7M for 1-30 days
24.4M / 24.4M for 31-60 days etc
so the calculation is 100% for each category. 
That is, it is not considering ALL the categories in the denominator.

So you likely need an ALL somewhere in your measure, like ALL(Age Buckets). However, you could try and use the interface to work it out if that suits .... by enabling the following on your measure 

1.jpg


 

1.jpg

 

1.jpg

View solution in original post

3 REPLIES 3
johnmelbourne
Helper V
Helper V

@johnmelbourne Thanks for your help again .

here i have followed the same and by table i can see the expected % and looks good but the same when i applied in line y axis chart it will shown like this :

% place.jpg

 

 

 

 

 

 

this looks abnormal and not a correct one , it showing consolidated % value ..

How to get the correct exact % value for each bars ?

Please help ..

I think your issues is the visual is doing calculations like
65.7M / 65.7M for 1-30 days
24.4M / 24.4M for 31-60 days etc
so the calculation is 100% for each category. 
That is, it is not considering ALL the categories in the denominator.

So you likely need an ALL somewhere in your measure, like ALL(Age Buckets). However, you could try and use the interface to work it out if that suits .... by enabling the following on your measure 

1.jpg


 

1.jpg

 

1.jpg

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors