Filter Based on Multi User Selected Values

Hi zkurdi,

Taking into that you have two columns on your model that have a date format this can be solved in differents ways depending on the slicing you want to have but also on the visuals you want to use.

But assuming that you are using the calendar table withou any relation to the Data table you need to calculate your measure with a filter something like this:

Measure =
VAR First_date =
    MIN ( Calendar[Date] )
VAR Last_Date =
    MAX ( Calendar[Date] )
RETURN
    CALCULATE (
        SUM ( Table[Column] );
        Table[OpenDate] >= First_Date
            && Table[OpenDate] <= Last_Date;
        Table[CloseDate] >= First_Date
            && Table[CloseDate] <= Last_Date
    )

When you select a month or more on your slicers this will return the result based on open and close dates, but be aware that this formulas need to bne adjusted to your model and your needs.

Some probably will not even need to have this filters if you do a not active relationship between the two columns and the calendare table and use the USERRELATIONSHIP formula to filter out the information.

Without any specific information or examples is difficult to give you an exact answer but there are several option on PBI.

Regards,

MFelix