Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I was searching for a DAX to return true if ID column value of Table 2 is present multiple times in different Group(Table 1).
Table 1 :
Table 2 :
I would like to create a "Check" DAX column to return ID value present in Table 1 multiple time for different Group
Solved! Go to Solution.
Hi @Anonymous ,
If you want to create a new table, try:
table = SUMMARIZE(Table1,Table1[ID],"ifmultiple",IF(CALCULATE(DISTINCTCOUNT(Table1[Group]),ALLEXCEPT(Table1,Table1[ID]))>1,"true","false"))
Best Regards,
Jay
Hi @Anonymous ,
If you want to create a new table, try:
table = SUMMARIZE(Table1,Table1[ID],"ifmultiple",IF(CALCULATE(DISTINCTCOUNT(Table1[Group]),ALLEXCEPT(Table1,Table1[ID]))>1,"true","false"))
Best Regards,
Jay
Hi @Anonymous
Try this:-
Column =
CALCULATE (
COUNTROWS ( __Table1 ),
FILTER ( __Table1, __table1[ID] = EARLIER ( ___table2[ID] ) )
) > 1
Output:-
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thanks for Replying, I was actually looking for grouping. As i have to check if the ID is present in different groups.
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |