Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
@Nimai123 , Try a measure
countx(filter(allselected(Table), [parent_id] =max(Table[Id])), Table[ID])
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |