Forum Discussion
Count of Row Combinations
Hi All, I'm trying to get the count of each row combination as shown below I've added the measure & added the following DAX: Count = CALCULATE (COUNTROWS (dbo),ALLEXCEPT (dbo, dbo[C1], d...
Thejeswar
Super User
Super UserHi ,I was able to achieve this by a different method. Instead of a measure, I am using a column.
1. Create a Column to concatenate all the five columns into one
concat = CONCATENATE('Table'[C1], CONCATENATE('Table'[C2], CONCATENATE('Table'[C3], CONCATENATE('Table'[C4], 'Table'[C5]))))
2. Create a column to count the number of rows
Count1 = COUNTROWS(FILTER('Table', 'Table'[concat] = EARLIER('Table'[concat])))
Output looked like below