Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everybody,
I need your help to add a make a calculate column for my table.
I have this kind of table, Where I want to add a new column that depend from the "category" and "id":
for each value, of column "id" : check if it's exist as a value on the two category (groupe 1 and groupe 2)
As the example :
Table :
Category | id | New column |
groupe1 | id1 | id1 |
groupe2 | id2 | N/A |
groupe1 | id3 | N/A |
groupe1 | id4 | N/A |
groupe2 | id5 | id5 |
groupe1 | id5 | id5 |
groupe2 | id6 | N/A |
groupe2 | id1 | id1 |
groupe2 | id2 | N/A |
Thanks you for your help.
Best,
Solved! Go to Solution.
@Anonymous , Try new column like
new column =
var _val = id
return
if(calculate(Distinctcount(Table[Category]),filter(Table,[Id]= _val)) =2, [id], "N/A")
@Anonymous , Try new column like
new column =
var _val = id
return
if(calculate(Distinctcount(Table[Category]),filter(Table,[Id]= _val)) =2, [id], "N/A")
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |