Compare the values from 2 columns.

Nimai123 — Tue, 17 Nov 2020 15:08:29 GMT

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

Re: Compare the values from 2 columns.

amitchandak — Tue, 17 Nov 2020 15:33:19 GMT

Nimai123 , Try a measure

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

topic Compare the values from 2 columns. in DAX Commands and Tips

Compare the values from 2 columns.

Re: Compare the values from 2 columns.