Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Consider the table below;
I'm looking to create a measure that shows the duplicate count on count name Id pairs without having to create the intermediate calculated column name Id pairs.
Thank you in advance for your time and assistance.
names | ID | name - ID Pairs | count name - ID pairs |
smith | 1100 | smith 1100 | 2 |
borke | 0012 | borke 0012 | 1 |
smith | 1100 | smith 1100 | 2 |
travis | 1234 | travis 1234 | 1 |
amadeus | 0987 | amadeus 0987 | 1 |
Solved! Go to Solution.
Hi @giordafrancis ,
Create a measure
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @giordafrancis ,
Create a measure
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Here you go:
CountPairs =
var __tbl = SUMMARIZE('Table';'Table'[ID];'Table'[names];"c";COUNTROWS('Table'))
return
MINX(__tbl; [c])
As seen here:
File is here.
Please mark as solution if this is what you are looking for. Thumbs up for the effort is appreciated.
Kind regards, Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |