Forum Discussion

Boycie92's avatar
Boycie92
Icon for Resolver I rankResolver I
8 years ago
Solved

Count Unique Rows using two columns

Hi,   I was wondering if someone can help   I have a model set up using direct query.   I have two column each have duplicates I want to be able to create a measure that would count only unique...
Need Help
Show and Tell
Tips and Tricks
RolandsP's avatar
RolandsP
Icon for Resolver IV rankResolver IV
8 years ago

You could combine 2 columns into a new column:

 

Combine = COMBINEVALUES("_", Table[ColumnA], Table[ColumnB])

 

And then do a distinct count on the new column:

 

Unique rows = DISTINCTCOUNT(Table[Combine])

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Boycie92

 

MEASURE =
COUNTROWS ( DISTINCT ( Table_Name ) )