Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a large table with one of the columns as 'CID' and there are multiple rows in this table with the same CID value.
There is another table with distinct CID codes that I need to match the previous table against.
So, I need to add a column to the large table that says CIDmatchs with logic being, if there is a match with the lookup table value; set it to 1 else 0 so I can count all the 1s together.
Can someone please help me with the logic for DAX or M any any method I can use to resolve this??
Solved! Go to Solution.
Hi @Anonymous, sounds to me like you have selected "Add Measure" instead of "Add Column"?
Just check that you have used "Add Column" and done so in the table that will hold the CID Flag. In this case we are adding it to the CID Table.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |