Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello:
I have a "Table" with three columns, A, B and C, filled with many different string values.
I want to find how many rows of that table have all three columns equal to another row in the table. In other words, find rows with duplicate "A+B+C". In a visual I would need a number, indicating how many non unique values there are, combining the three columns.
Is there a formula to achieve this or do I have to concatenate all three columns in one first and then somehow count the duplicates?
Thank you very much and regards.
Hi @superjam
In general that depends on the filter context which essentially depens on the visual itself. However, The following should work in a card visual
Count =
COUNTROWS (
DISTINCT ( SELECTCOLUMNS ( "A", 'Table'[A], "B", 'Table'[B], "C", 'Table'[C] ) )
)
Hello,
Just after posting the last response, I figured it out: create a new column concatenating the three columns and then use the idea of @FreemanZ to calculate the duplicate ones.
Thank you, @FreemanZ
The function DISTINCT() counts unique values in one column of the table. So, your measure gives the repeated values in one column.
But how about the following example:
Only one row is duplicated (marked in yellow), because only in that case all three columns are equal with each other. I hope this clarifies the problem.
Thanks again.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
41 | |
29 | |
23 | |
22 | |
22 |