Forum Discussion
CWhite82
2 years agoRegular Visitor
Accts Receivable Total Overdue
Hi Community, Wonder if you could help me, Within AR i'm looking show the total ocverdue within the below, currently i'm using a measure to determine the age of the debt by days and then actergori...
- Anonymous2 years ago
Hi CWhite82
For your question, here is the method I provided:
Here's some dummy data
"Table"
You can create a measure.
Total ocverdue = CALCULATE( SUM('Table'[ocverdue]), FILTER( 'Table', 'Table'[Sector] = MAX('Table'[Sector]) // Grouped by Sector && 'Table'[Cash Overdue Range] IN {"0-7", "8-15", "16-30", "31-60", "61+"} ) )If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Brightsider
Resolver I
2 years agoTry this:
SUMX(FILTER(WhateverYourTableIsCalled[Cash Overdue Range] in {"61+", "60 - 31", "30 - 16", "15 - 8", "7 - 0"}), [WhateverYourOverdueAmountColumnisCalled])