Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@MH3 Create a measure like below:
MEASURE = CALCULATE(AVERAGE(TableName[Overdue Column]),ALLEXCEPT(TableName,TableName[Customer Column]))
@MH3 Create a measure like below:
MEASURE = CALCULATE(AVERAGE(TableName[Overdue Column]),ALLEXCEPT(TableName,TableName[Customer Column]))
AsSalam O Alikum @Tahreem24
I have used your formula in TOP 10 (Filter by Customers)
But its not working as expected
@MH3, Wa laikum Assalam.
Try to take only Customer column and newly created above measure and then check.
@Tahreem24 Yes, but It should show by OverDueDays Column
(your measure works only with CustomerName)
magr uske sath work karna chaiye 😞
@MH3 ALright then make this adjustment in that measure:
MEASURE = CALCULATE(AVERAGE(TableName[Overdue Column]),ALLEXCEPT(TableName,TableName[Customer Column], TableName[OverDueDays]))
@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?
2) ALLEXCEPT(Receivables,Customer[CustomerName],Receivables[OverDueCol]))
There is a 2 Customer difference between them, which one should be correct?
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |