Forum Discussion
Getting values from a column associated with a value on the same row in PowerBi
What I am trying to do is to get a value on the same row from one column that is associated with a value on another column on the same table. Currently I have 4 columns. As shown below, I'll call th...
lbendlin
Super User
Super UserYou need to get out of the current filter context for that.
custom_column =
var s = Objects[string id]
var f = SUMMARIZE(filter(Objects,Objects[string id]=s),Objects[file id])
return CALCULATE(CONCATENATEX(Objects,Objects[string],","),All(Objects),Objects[file id] in f)
By the way your statement "So in this example it will return everything except the cell that has "VIEW"." is not entirely correct.
Thank you so much for this. I was hoping to get each value that was associated to the same file id as current set on a seperate row. I would probably need to create a new table and do this? Sorry if i wasnt clear.
Unless this would also take a cell thats blank and then I would be able to break down the column by using a comma delimiter to get everything on cell seperated out to their own cells