Daily average

Hey,

unfortunately calculated tables used in the data model and not as a filter or input for other functions do not update depending on changes in a slicer selection, this is by design.

I created a little Power BI file that uses this measure

average no of rows per day = 
var maxSelectedDate = ALLSELECTED('Table1'[Date])
return
AVERAGEX(maxSelectedDate
	,CALCULATE(count('Table1'[RowID]))
)

this measure can used on card visual, the following screenshot shows that there are an average number of rows of 2.5 for both selected days (4 from 28th of August and 1 from 1st of September.

Hope this is what you're looking for.

Regards