PowerBI DAX filter

Anonymous — Thu, 19 May 2022 09:48:07 GMT

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?

Re: PowerBI DAX filter

selimovd — Thu, 19 May 2022 14:43:51 GMT

Hey Anonymous ,

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.bi

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

topic PowerBI DAX filter in DAX Commands and Tips

PowerBI DAX filter

Re: PowerBI DAX filter