Average value in card

[piotrkopti]

Hello,

In matrix table I have measure (DISTINCTCOUNT) that show data per day. Now I wish to have card to show average value from this days.

for now, DISTINCT_COUNT mesaure is simple DISTINCTCOUNT(table[ID])

[Anonymous · Accepted solution]

[Daily Average] =
AVERAGEX(
	// Change this ugly name. You're not
	// going to expose this monster to your
	// users, right?
	DISTINCT( T[vt_date_c_just_date] ),
	[Distinct_Count]
)