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...
dax formula
  • 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.

Anonymous's avatar
Anonymous
Not applicable
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.