I’m trying to create a measure which calculates (Average) days on site for many different locations. I’m able to get the days on each site based on the measure below.
Days on Site =
COUNTROWS ( DISTINCT ( ‘Lem Entry’[Date])
My PBI table looks looks like the attached.
data.csv (190 Bytes)
How would I create a measure that would show the average of those ‘days on site’ if I created one card?