Total average of customers

[pawelj795]

Hi,
I have a table and DAX like below.


Below customers I have invoices

Now, I want to calculate average delay per customer so it's actually average of average.


But it gives wrong value.
I want show my result as Card visual.

[v-eachen-msft]

Hi @pawelj795 ,

Could you please share your sample data and expected result to me if you don't have any Confidential Information? Please upload your files to OneDrive for Business and share the link here.

[Greg_Deckler]

This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

[pawelj795]

@Greg_Deckler 

I tried your solution but it still return the same value.

[Greg_Deckler]

Going to need sample data and expected output. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490