topic Re: How Compare values across rows in two columns in DAX Commands and Tips

How Compare values across rows in two columns

KelzMaJ — Tue, 26 Sep 2023 16:45:38 GMT

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

The result should be a table with the matching values such

ERD — Tue, 26 Sep 2023 16:52:09 GMT

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 — Tue, 26 Sep 2023 22:27:24 GMT

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

KelzMaJ — Wed, 27 Sep 2023 06:57:54 GMT

Thank you so much, this worked!