topic Re: Average of a measure in DAX Commands and Tips

Average of a measure

rsch91 — Tue, 17 Dec 2024 11:59:03 GMT

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.

Re: Average of a measure

rohit1991 — Sat, 23 Aug 2025 11:48:38 GMT

Could you please try this measure:

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

Steps:

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

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

Re: Average of a measure

Kedar_Pande — Tue, 17 Dec 2024 13:59:38 GMT

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

Re: Average of a measure

rsch91 — Thu, 19 Dec 2024 08:34:43 GMT

Yes, this worked, thank you!