topic Filter content based on two columns in DAX Commands and Tips

Filter content based on two columns

Anonymous — Thu, 01 Feb 2024 12:07:26 GMT

I've got a directconnection to a source in Power BI and I want to filter upon two things.

so in one table I have Accounts and in the other table I have Tag Name & Tag status

In a second matrix on the same page, I want to filter out all accounts which have Tag Name "Tag 1" and Tag Status "Active"
How can I achieve that? as I'm trying to do this but I'm failing to do so.

Re: Filter content based on two columns

lbendlin — Fri, 02 Feb 2024 01:12:29 GMT

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Re: Filter content based on two columns

Anonymous — Fri, 02 Feb 2024 02:40:25 GMT

Hi Anonymous ,

I created some data:

Table1：

Table2：

Here are the steps you can follow：

1. Create measure.

Measure = IF( MAX('Table1'[Tag Name])="Tag1"&&MAX('Table1'[Tag Status])="Active",BLANK(),MAX('Table1'[Tag Status]))

2. Select [Account – turn off “Show” items with no data.

3. Result:

Note: This fits a row of data all blank(), if one of them contains data, the entire row will not be filtered.

If it doesn't meet your desired outcome, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Re: Filter content based on two columns

Anonymous — Mon, 19 Feb 2024 07:34:52 GMT

Hi,

Sorry for my late reply but the data is a little bit different .. 🙂

Basically it is a table where Tag name only exists for certain actions when they are active and do not exist when not active. 😉

So I want to filter out all accountkey where Tag1 doesn't exist

Re: Filter content based on two columns

Anonymous — Fri, 23 Feb 2024 07:06:03 GMT

Hi Anonymous ,

Here are the steps you can follow：

1. Create measure.

Flag = var _select= SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[Account Key]=MAX('Table'[Account Key])),"Tag",[Tag Name]) return IF( "Tag1" in _select,MAX('Table'[Tag Status]),BLANK())

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly