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 😞