Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
This will likely be a very simple answer but I'm hitting a wall for some reason.
Essentially, If the client ID has a certin activity against it, I need a True or false/1 or 0 next to the entire client record. For exmple, see the table below.
Activites
client ID | activity |
1 | a |
1 | b |
1 | c |
2 | a |
2 | a |
2 | a |
3 | a |
3 | b |
3 | b |
4 | c |
4 | c |
4 | c |
I need to add a colum that identifies all clients who had NOT had activity C.
result
Clinet ID | activity | new |
1 | a | 0 |
1 | b | 0 |
1 | c | 0 |
2 | a | 1 |
2 | a | 1 |
2 | a | 1 |
3 | a | 1 |
3 | b | 1 |
3 | b | 1 |
4 | c | 0 |
4 | c | 0 |
4 | c | 0 |
As client 1 and 4 have both had Activity C, all their records needs to be False or 0.
Ideally, this needs to be completed in DAX.
Thanks in Advanced.
Edit/note
Client ID on my actual table is Alphanumeric.
Solved! Go to Solution.
@Anonymous For a measure try this:
For a calculated column try this:
PBI file is attached below my signature.
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |