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]))

     

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

Tahreem24  Yes, but It should show by OverDueDays Column

(your measure works only with CustomerName) 


magr uske sath work karna chaiye 😞

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?