Forum Discussion

Regular Visitor

8 years ago

Solved

DISTINCT COUNT AND GROUP BY

This has been asked many times in this forum. But I'm a newbie and haven't found any satisfying answer so far in this forum, so please bear with me. :) I have a table that goes like this: Count...

Need Help

ChrisMendoza
8 years ago
plartoo,
Using the measure from your other post https://community.powerbi.com/t5/Desktop/Finding-DISTINCT-COUNT-of-Brands-by-Country/m-p/420940#M193501,

Seemingly, I could not find a way to show [Spend] alongside the Distinct Count so I placed [Spend] in a Tooltip.

Anonymous

Not applicable

8 years ago

plartoo, try this:

Measure = countx(DISTINCT(sourceTable),sourceTable[Brand])

plartoo

Regular Visitor

8 years ago

Thank you for your suggestion. But

Measure = COUNTX(DISTINCT(SampleDataForDashboard), SampleDataForDashboard[Brand])

returns TOTAL number of brands in each country. Is there a way to get DISTINCT COUNT instead?

Forum Discussion

DISTINCT COUNT AND GROUP BY

Related content

count distinct

Count of groups of distinct count by group

Distinct Count per Group

Grouping counts and distinct counts in DAX

Distinct Count