Filter content based on two columns

[Sabre77]

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. 

[Anonymous · Accepted solution]

Hi  @Sabre77 ,

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

[Anonymous]

Hi  @Sabre77 ,

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

[lbendlin]

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

[Sabre77]

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