Average of a measure

[rsch91]

Hi all,

I want to calculate the average of a measure. A calculated table or column is not an option as my company uses semantic models and scheduling an automatic refresh isn't possible with calculated columns/tables in semantic models. 

The measure 'Time between registration and first contact with customer' is the time in working days and is a whole number. I use it to plot the amount of days per work order. 

I also want to calculate the average amount of working days per supplier and show it in a clustered column chart, using this measure. It is not possible. How do I do this? I've already tried making a new measure for the average, trying AVERAGE([Time between registration and first contact with customer]) but AVERAGE only works using columns, and this is not information stored in a column but a measure. 

Thank you. 

[Kedar_Pande]

@rsch91 

Avg Time Per Supplier = 
DIVIDE(
SUMX(
VALUES('Work Orders'[Supplier]),
[Time between registration and first contact with customer]
),
COUNTROWS(VALUES('Work Orders'[Supplier]))
)

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[rohit1991 · Accepted solution]

Average Working Days =
AVERAGEX(
SUMMARIZE('YourTable', 'YourTable'[Supplier], "Days", [Time between registration and first contact with customer]),
[Days]
)

Steps:

1. SUMMARIZE groups by Supplier and calculates the measure.
2. AVERAGEX averages the measure values.

Place Supplier on the axis and this measure in values for your chart.

[rsch91]

Yes, this worked, thank you!