Forum Discussion

dominikRieder's avatar
dominikRieder
Frequent Visitor
6 years ago
Solved

Filter Table with OR condition on different columns

Hello everyone,   I would like to filter a table on its Date-Values and on some Status-Values, e.g: ID Date Status 1 Dec. 2019 1 2 Jan. 2020 1 3 Feb.2020 2 4 Mar.2020 2 ...
Need Help
Tutorial Requests
  • MFelix's avatar
    MFelix
    6 years ago

    Hi dominikRieder ,

     

    Create a calendar table and a status table to use on your slicers now add the following measure to your data:

    Measure =
IF (
    (
        SELECTEDVALUE ( 'Table'[Date] ) <= MAX ( 'Calendar'[Date] )
            && SELECTEDVALUE ( 'Table'[Date] ) >= MIN ( 'Calendar'[Date] )
    )
        || SELECTEDVALUE ( 'Table'[Status] ) IN VALUES ( 'Status'[Status] );
    1;
    BLANK ()
)

     

    Now filter you information based on the value 1 of the measure check the PBIX file attach.

     

     

MFelix's avatar
MFelix
Super User
6 years ago

Hi dominikRieder ,

 

Create a calendar table and a status table to use on your slicers now add the following measure to your data:

Measure =
IF (
    (
        SELECTEDVALUE ( 'Table'[Date] ) <= MAX ( 'Calendar'[Date] )
            && SELECTEDVALUE ( 'Table'[Date] ) >= MIN ( 'Calendar'[Date] )
    )
        || SELECTEDVALUE ( 'Table'[Status] ) IN VALUES ( 'Status'[Status] );
    1;
    BLANK ()
)

 

Now filter you information based on the value 1 of the measure check the PBIX file attach.

 

 

dominikRieder's avatar
dominikRieder
Frequent Visitor
6 years ago

Hi MFelix, thank you for the quick reply. I will try that out and let you know whether it worked for me