Forum Discussion

KelzMaJ's avatar
KelzMaJ
Regular Visitor
2 years ago
Solved

How Compare values across rows in two columns

I am trying to create a new table that shows rows with matching data in two separate columns.

 

eg

 

Ice-cream flavourCake Flavour
VanillaChocolate
Cookie CrunchCookie Crunch
StrawberryBanana
BlackcurrantBlackcurrant
MintCarrot

 

The result should be a table with the matching values such 

 

eg

Ice-cream flavourCake Flavour
Cookie CrunchCookie Crunch
BlackcurrantBlackcurrant
  • ERD's avatar
    ERD
    2 years ago

    Hi KelzMaJ , you can create a measure and use it for filtering the visual.

    Measure:

    Measure = 
IF ( MAX ('Table'[Ice-cream flavour] ) = MAX ( 'Table'[Cake Flavour] ), 1, 0 )

    Filter:

     

3 Replies

  • ERD's avatar
    ERD
    Community Champion
    2 years ago

    Hi KelzMaJ , you can create a measure and use it for filtering the visual.

    Measure:

    Measure = 
IF ( MAX ('Table'[Ice-cream flavour] ) = MAX ( 'Table'[Cake Flavour] ), 1, 0 )

    Filter: