Forum Discussion
Calculated column based on table relationship
Hello, I have a problem that can be summed up like this: I have a "Item" table and a "Sales line" table, with a many to one relationship based on Item ID (each Item has zero to many Sales line . Ea...
Anonymous , You can try a new column like
new column Flag =
var _1 = countx(relatedtable(Sales), sales[value]) +0
return
if(_1 >0,1 ,0)
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8Or measure count(sales[value]) +0 , should also work with me item
Anonymous , You can try a new column like
new column Flag =
var _1 = countx(relatedtable(Sales), sales[value]) +0
return
if(_1 >0,1 ,0)
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Or measure count(sales[value]) +0 , should also work with me item