Forum Discussion

CWhite82's avatar
CWhite82
Regular Visitor
2 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    2 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.