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

AsSalam O Alikum Tahreem24 

I have used your formula in TOP 10 (Filter by Customers)

But its not working as expected

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

MH3, Wa laikum Assalam.

Try to take only Customer column and newly created above measure and then check.

 

  • 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?