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
AG1902
New Member

Calculating difference in total overdue for ranked customer names

Hi All,

 

I am just working on a weekly accounts receivables report. My dataset contains information about customers from different regions and entities and AR balances for those customers as of every Monday.
In my report I put a summary table which allows for quick scanning - it shows Top 5 debtors + OTHER (for a given Monday I rank all customers by total overdue amount and if the ranking <= 5 then customer name is displayed, otherwise I put everything into "OTHER" category - please see first picture).
Users are able to choose a specific date for which they want to see the debtors ranking and total overdue balances. I have been also asked to add a column with a change in total overde (this vs previous week). I have created a measure to show the delta but unfortunately when I put it into my table, more than 5 debrors for every region appear (I get top 5 debtors for this week and those who ARE NOT in top 5 this week but were on the top positions last week). 
I tried to make a workaround in a measure to not display those names (please see second picture) but it does not work - the total change for a given region is not the sum of the top 5 debtors + other.
Do you have any ideas how to solve this?
Thanks in advance for your help!

AG1902_0-1664440856332.png

 

AG1902_1-1664440886829.png

 



1 REPLY 1
v-jayw-msft
Community Support
Community Support

Hi @AG1902 ,

 

Please share some sample data so that we could test the formula.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.