cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Match 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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Match with a measure

Hi @PowerBI123456 

take a look at the following solution:

 

04-09-_2020_22-14-10.png

 

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)

View solution in original post

1 REPLY 1
Highlighted
Super User II
Super User II

Re: Match with a measure

Hi @PowerBI123456 

take a look at the following solution:

 

04-09-_2020_22-14-10.png

 

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)

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors