PowerBI DAX filter

[tiffanyt123]

Hi there,

I have the following matrix table on powerBI - columns marked with "1" and "2" come from their source data respectively. Issue now is that I want to filter the table to when rows in match each other, i.e when columns 1 and 2 are both Essential Health etc

Is there a way to create a DAX formula to filter?

[selimovd]

Hey @tiffanyt123 ,

I don't really know what you want to do.

You can create a measure like that:

Is Franchise the same =
IF (
    MAX ( 'Table 1'[Franchise] ) = MAX ( 'Table 2'[Franchise] ),
    "They are the same",
    "They are not the same"
)

Then you could filter the visual for the measure. Check this article about filtering visuals by a measure (middle of the article, filter by measure):

Automatically filter report on actual date with calculated column and with measure - What the fact.b... 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic