Forum Discussion
PowerBI123456
Post Partisan
Post PartisanMatch with a measure
Hi, I have 2 tables with a 1 to many relationship. The many table might not always have something from the table 1. How can I create a measure (not calculated column) and see which ones do have a match?
take a look at the following solution:
Match in Table2 ? = VAR _CurrentValue = MAX(Table1[Value]) RETURN IF(CALCULATE(COUNTROWS(Table2),Table2[Value] = _CurrentValue) > 0 , "Yes", "No")With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
1 Reply
- FrankAT
Community Champion
take a look at the following solution:
Match in Table2 ? = VAR _CurrentValue = MAX(Table1[Value]) RETURN IF(CALCULATE(COUNTROWS(Table2),Table2[Value] = _CurrentValue) > 0 , "Yes", "No")With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)