Calculate Overdue Balance and Total Debt with one slicer

[YasinTaha]

Hi every one,

I searched on forums, but no solutions. Please help me !

I have a table as below named 'table1'; and when I select the slicer between two days, I want to take the result as below;

Thank you

[YasinTaha]

It is awesome bro. This resolve my problem. Thank you so much

[amitchandak · Accepted solution]

@YasinTaha , Create a date table , Join that with Invoice date and Due date. In case due date join is the one inactive then use use relation and this type of formulas

Total Deb = sum(Table[Amount]) // Active join of invoice to be used

Overdue Invoices = calculate(sum(Table[Amount]),USERELATIONSHIP(Date[Date], Table[Due Date])) // Activate Due Date join

refer my Video for use relation:https://www.youtube.com/watch?v=e6Y-l_JtCq4

or this blog -https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[wdx223_Daniel]

@YasinTaha it is a trick about userelation ship. first to create a date table, then establish the relationship between date and Invoice date, which is active, and between date and overdue date, inactive.

[YasinTaha]

Thank you so much, but I had no ability to solve my problem with your solution.

[StefanoGrimaldi]

this looks like a tricky one actually, since anything you do with the slicer will affect and filter the whole table, and you cant parse date formate value as user interface parameters, so you do can do this by creating a second table just to manage the slicer with the overdue amount: 

Table 2 = SUMMARIZE('Table','Table'[client],'Table'[Due date],"overdue amount",SUM('Table'[amount]))

relantionshipp type: 

there you go, basically this will filter the overdue new table and ensure the original one doesnt change upon altering the filter, will result in what you describe you looking for, 

if this was of help and solve your question please mark as solution for others to find it, and gives some kudos if you liked the solution. 

[YasinTaha]

Thank you so much, but I had not such ability to solve my problem with your solution.