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 should show only one customer per OverDue Average

Can anyone help? 

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

     

7 Replies

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