How to filter for 2 conditions

[Anonymous]

I want to filter my table for two conditions: There are 3 fields in table
Date Posted    Date applied   Type
02/01/2020     03/01/2020       1
03/01/2020     04/01/2020       1
01/01/2020     02/01/2020       2
02/01/2020     03/01/2020       2

I only want date posted for feb for type 1  and date applied for feb for type 2 so I would end up with only 2 records in my file the first and the third.   Is it possible to do with slicers?

[TomMartens · Accepted solution]

Hey @Anonymous ,

you have to create unrelated tables that you can use to feed the slicers.

Then you have to create a measure that filters the "original" table, that meaure can look like this:

measure = 
CALCULATE(
    SUM('tablename'[numeric column])
    ,TREATAS('unrelated table from slicer1'[columnname] , 'tablename'[Date Postes])
    ,TREATAS('unrelated table from slicer1'[columnname] , 'tablename'[Date Applied])
    ,...
)

Hopefully, this helps to tackle your challenge.

Regards,

Tom

[Anonymous]

It works!

[parry2k]

@Anonymous it is possible but you have to create separate table with each slicer and then use the selected value in your measure to filter you data table, in short, it is possible, not out of the box.

[Anonymous]

I want my user to select feb as their date and not worry about the type.  So the date field applies to posting date if type =1 or applied date if type 2.  Is there a better way to do this besides slicers?