Average of a measure

[matthewL]

Hi everyone.

I'm trying to calculate the average value of the CORRECT_STOCK for all the items I've got in my DB. The problem is that I find it difficult to calculate the average of a measure, without having a column or table.

I made two attempts to calculate it, but as you can see the values are not correct (in the first case I get the last value of CORRECT_STOCK for the item, while in the second I get a too low value.

Warehouse.pbix 

Can you help me? Thank you in advance.

[themistoklis]

@matthewL 

This measure works for me:

Average New = AVERAGEX(VALUES('Calendario RIDOTTO'[Date]),[CORRECT_STK])

See attached workspace.

[matthewL]

Sorry but the value is the same for all items (283.85), or am I wrong? However thanks for the help.

[themistoklis · Accepted solution]

@matthewL 

If you open the workspace that i have attached on the message you will notice that the first field comes from MSTR_ITM table and not FACT_MOVE table.

It seems that these 2 tables are not connected properly in the data model.

Also in the filter page the page filter comes MSTR_ITM table and not FACT_MOVE table