Forum Discussion
Nimai123
Post Patron
Post PatronCompare the values from 2 columns.
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
Nimai123 , Try a measure
countx(filter(allselected(Table), [parent_id] =max(Table[Id])), Table[ID])
1 Reply
- amitchandak
Super User
Nimai123 , Try a measure
countx(filter(allselected(Table), [parent_id] =max(Table[Id])), Table[ID])