Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Evening,
I'm trying to write a DAX expression that counts the number of IDs that occur twice or more in a table.
For instance:
ID |
A |
B |
C |
A |
B |
A |
...should return 2 as both A and B occur twice or more in the column. Thanks for your assistance.
=
COUNTROWS(
FILTER( VALUES( DATA[ID] ), CALCULATE( COUNTROWS( DATA ) ) > 1 )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi,
You can use this measure:
Mesm=
Var t = SUMMARIZE('Table','ID',"Cnt",CountRows('Table'))
Return
CountRows(FILTER(t,[Cnt] >=2))
And, after creating the measure, you can use a card and drag ( or dispaly) the measure on the card, and you'll see the count you are looking for.
Best regards.
Hello
Try this
measure
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
39 | |
25 | |
21 |