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
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Boycie92,

After test, the measure formula Zubair_Muhammad posted is right. You can create a card visual to show the result.



Please mark the right reply as answer, so more people will find workaround easily and clearly.

Best Regards,
Angelia