Compare the values from 2 columns.

[Nimai123]

Hello Guys,

I have 2 columns in a single table.

Need to compare parent_id with Issue_id, as in when a value of parent_id is present in the issue_id then you much count the row and same for the other rows of the column.

Sample Data:

Desired count output as a measure = 6       

Due to 9,0,1,5,4,2.......Present in the issue_id coulumn.

Need to create a column also for the same logic but as when there is a match the value of the row for that parent_id will be 1, if not a match then 0

@amitchandak 

[amitchandak · Accepted solution]

@Nimai123 , Try a measure

countx(filter(allselected(Table), [parent_id] =max(Table[Id])), Table[ID])