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 flavour Cake Flavour Vanilla Chocolate Cookie Crunch Cookie Crunch St...
  • 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:

     

ERD's avatar
ERD
Icon for Community Champion rankCommunity 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:

 

KelzMaJ's avatar
KelzMaJ
Regular Visitor
2 years ago

Thank you, let me try and get back to you.