Forum Discussion
Unique Counts by Hour
Hi! I'm trying to count the unique number of combinations between two columns by hour. For example: I have data that looks like this: I want to get the counts of unique pairi...
First, check if the default summarization of the column hour is “Don’t summarize”:
Then, create a new column for the Unique combination you want to count:
Unique Combination = CONCATENATE('Table'[Column1],'Table'[Column2])So, create a measure Counts:
Counts = COUNT('Table'[Hour])Finnaly, you can create you a table to visualize your result:
If it helps, pls mark this post as a solution and give a kudo. Thanks
Nathaniel_CThanks for the response.
I received:
Too many arguments were passed into the COUNT function. The maximum argument count for the function is 1.
Hi Anonymous ,
Sorry dropped a paren after hour
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
= CALCULATE (COUNT(table[Hour]),ALLEXCEPT(table,table[Column 1],table[Column 2]))