Averaging Distinct Numbers

[Anonymous]

Hey All!

So I am looking into a very paticular issue here and kinda looking for help. I have a client who is looking to get the Average of something but not have have an over representation. Example Below:

Video	Channel	Score
1	A	34
2	A	34
3	A	34
4	B	20

They are looking to only average 1 score from channel A with channel B so Channel A is not over represented. Is this even possible?

Thanks!

[Zubair_Muhammad · Accepted solution]

HI @Anonymous

Please give this a shot

Measure =
AVERAGEX (
    SUMMARIZE (
        TableName,
        TableName[Channel ],
        "Distinct Values", AVERAGE ( TableName[Score] )
    ),
    [Distinct Values]
)