Forum Discussion
SteveIOW
Helper II
4 years agoAverage of DistinctCount PCM
Dear all, as you can see below I am trying to find the average of the last 6 months data. The data is loaded in as individual users and the date the access a website. I am countinf the number th...
mh2587
Super User
4 years agoAverage Per Country =
VAR _A =
SUMMARIZE (
'Table',
'Table'[Country],
'Table'[Product],
"DisC", DISTINCTCOUNT ( 'Table'[Color] )
)
RETURN
AVERAGEX ( _A, [DisC] )
// Modify it with your scenario