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