Calculate average of a measure per 2 filters

[jessicarocha]

I would like to calculate the average of materials ordered in the same day by customers. 

I was able to create an average that gives me the number of orders per customer: 

Number Materials per order =

CALCULATE(

DISTINCTCOUNT('Fact'[IDNR]), FILTER('Fact', 'Fact'[KDNR ENK]), filter('Fact', 'Fact'[Erstelldatum ENK])

)

However, when I try to create the average, it is not working. The measure I used is:

test =

CALCULATE(

AVERAGEX(

Filter('Fact', 'Fact'[KDNR ENK]&& 'Fact'[Erstelldatum ENK].[Date]),

[Number Materials per order]

)

)

I created a power bi example with a dummy data that you can find here:
Dummy Power BI 

Thanks in advance for helping me!

[Ashish_Mathur]

Hi,

I do not know how you arrived at your denominator (7) for your test measure but you can simplify your existing measure to

Number Materials per order = DISTINCTCOUNT('Fact'[IDNR])

[jessicarocha]

Hi @Ashish_Mathur 

I consider a order the combination from customer and date. Thus, I want to do an average of how many products are sold per order. 
So, it is necessary to count the IDNR per group (customer and date) and then average in the end. 
The 7 comes because I have 7 rows in the table. 7 different combinations of customers and dates. 
@lbendlin achieved that by using summarize and it works! 
so thank you anyway. 

Kind regards, 
Jéssica

[lbendlin · Accepted solution]

You may be overengineering this a bit.

See attached.

[jessicarocha]

@lbendlin thank you! exactly what I wanted. and much simpler that I was thinking 😄 
I did not know summarize yet. thanks!