Forum Discussion
Average on distinctCount
Dear everyone, I need help to have the average of a distinctCount. I did some research , but without success. I hope that I will be clear: I have the data below: I would like to know the ...
Hi Anonymous
Try this measure:
Average Per Country = VAR _A = SUMMARIZE ( 'Table', 'Table'[Country], 'Table'[Product], "DisC", DISTINCTCOUNT ( 'Table'[Color] ) ) RETURN AVERAGEX ( _A, [DisC] )Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/Do you like to see the FIFA Word Cup Dashboard:
Hi Anonymous
Try this measure:
Average Per Country =
VAR _A =
SUMMARIZE (
'Table',
'Table'[Country],
'Table'[Product],
"DisC", DISTINCTCOUNT ( 'Table'[Color] )
)
RETURN
AVERAGEX ( _A, [DisC] )
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Do you like to see the FIFA Word Cup Dashboard:
Thank you very very much VahidDM !!! It works very well ! You saved my day 😁