Forum Discussion

AlxFelipe's avatar
AlxFelipe
New Member
3 years ago

Measure as filter

Hello, i want use two measure as interval to filter another visual. First measure return the initial date, and the another, a final date.
These measures comes from the first and the last monitoring date, using segmentation filter on page for select the local. Diferent locals, diferents results.

 

It shows all the dates when it rained, must show the dates where rained between first and last monitoring. Like this:

 

At the side bar Filters, i can't use measure as filters.

I tried create another table using this DAX:

 

 

 

 

IntervaloChuvaFen = 
FILTER('pluviometer_monitoring_list',
    'pluviometer_monitoring_list'[Date_short] >= [Min Fen] &&
    'pluviometer_monitoring_list'[Date_short] <= [Max Fen]
)

 

 

 

 

 But goes wrong and do not showed the correct interval. Any idea?

Need Help
Tutorial Requests

2 Replies

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    Create a new measure like

    Date is visible =
VAR ReferenceDate =
    SELECTEDVALUE ( 'pluviometer_monitoring_list'[Date_short] )
RETURN
    IF ( ReferenceDate >= [Min Fen] && ReferenceDate <= [Max Fen], 1 )

    and use that as a visual level filter, to only show when the value is 1.