Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |