Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 distinct count color per country per product, so I created a new measure DistinctCount. So I created a matrix that display these info:
But now, I need the average per country in a diagram or table like below in blue. I don't know how to do it. Can you please help me ? Thank you very very much !
Solved! Go to Solution.
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:
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 25 |
| User | Count |
|---|---|
| 124 | |
| 87 | |
| 70 | |
| 66 | |
| 65 |