Forum Discussion

omdavies's avatar
omdavies
Helper I
5 years ago

Inclusive Page / Visual Filters

Is it possible to configure a report to filter inclusivly ?  Scenario to use is:   Table of Incidents    Title Status Open Date Close Date   I would like to create a table of incidents that ...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi omdavies ,

 

According to my understand, when select 2021 in Close Date ,you want to display one of the open date and close date is 2021. For example, the following data meet the conditions, right?

 

open dateclose date
2020/1/12021/1/2

2021/1/3

2020/1/4
2021/1/52021/1/6

 

If so , you need to create a single table for close date and use the following formula:

 

Measure =
IF (
    YEAR ( MAX ( 'Worksheet'[Open Date] ) )
        IN ALLSELECTED ( 'Table'[Close Year] )
            || YEAR ( MAX ( 'Worksheet'[Close Date] ) ) IN ALLSELECTED ( 'Table'[Close Year] ),
    1,
    0
)

 

Then apply the measure to filter pane ,set as "is 1". The final output looks like this:

Here is the pbix file.

 

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

 

Best Regards,
Eyelyn Qin