Averages OverDue by Customers

[MH3]

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? 

[Tahreem24 · Accepted solution]

@MH3 Create a measure like below:

MEASURE = CALCULATE(AVERAGE(TableName[Overdue Column]),ALLEXCEPT(TableName,TableName[Customer Column]))

[MH3]

AsSalam O Alikum @Tahreem24 

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

But its not working as expected

[Tahreem24]

@MH3, Wa laikum Assalam.

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

[MH3]

@Tahreem24  Yes, but It should show by OverDueDays Column

(your measure works only with CustomerName) 

magr uske sath work karna chaiye 😞

[Tahreem24]

@MH3  ALright then make this adjustment in that measure:

MEASURE = CALCULATE(AVERAGE(TableName[Overdue Column]),ALLEXCEPT(TableName,TableName[Customer Column], TableName[OverDueDays]))

[MH3]

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

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?