I have created a new calculated column in the data model that is a combination of 5 columns.
I need to some how count the number of times there 2 or greater matches in this column. If 2 or 10 rows of data match I need it to count it as 1. If only 1 row is unique it would be a 0
Need this to be done using a Dax function since I will be using this data in a pivot table.
I went ahead an uploaded a sample with data and what I'm looking for.
Thanks!
Bookmarks