Forum Discussion

MH3's avatar
MH3
Icon for Helper V rankHelper V
4 years ago
Solved

Averages OverDue by Customers

Hi, I have a OverDue Column for each invoices, and I have a measure for Average OverDue ( but its getting Average on per invoices not on Customer) The customer names are repeating it shou...
Need Help
Show and Tell
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    MH3 Create a measure like below:

    MEASURE = CALCULATE(AVERAGE(TableName[Overdue Column]),ALLEXCEPT(TableName,TableName[Customer Column]))

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

MH3  ALright then make this adjustment in that measure:

MEASURE = CALCULATE(AVERAGE(TableName[Overdue Column]),ALLEXCEPT(TableName,TableName[Customer Column], TableName[OverDueDays]))

 

MH3's avatar
MH3
Icon for Helper V rankHelper V
4 years ago

Tahreem24 
I am confused a bit,

I have calculated OverDueDays in my Receivables Table according to the invoices

But I have used your two Formulas and they are showing different results

Which one is the correct one?

1) ALLEXCEPT(Customer,Customer[CustomerName]))


With AllExcept( Customers, CustomerName)

2) ALLEXCEPT(Receivables,Customer[CustomerName],Receivables[OverDueCol]))


ALLEXCEPT(Receivables,Customer[CustomerName],Receivables[OverDueCol]))

There is a 2 Customer difference between them, which one should be correct?

  • MH3's avatar
    MH3
    Icon for Helper V rankHelper V
    4 years ago

    Thanks Tahreem24 

    I figured it out I was doing a mistake.

    Now, its showing results as expected but there customer top 10 can be sorted ascending?