Forum Discussion

SteveIOW's avatar
SteveIOW
Icon for Helper II rankHelper II
4 years ago

Average 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...
Need Help
mh2587's avatar
mh2587
Icon for Super User rankSuper User
4 years ago
Average Per Country = 
VAR _A =
    SUMMARIZE (
        'Table',
        'Table'[Country],
        'Table'[Product],
        "DisC", DISTINCTCOUNT ( 'Table'[Color] )
    )
RETURN
    AVERAGEX ( _A, [DisC] )
// Modify it with your scenario