Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Relative Filter Help Please

Hi All,   I am trying to work out how, when i select a month filter (from a calendar table) to apply a filter (>90 days from the selected month) to a card.   So the >90 days always references the...
Need Help
TomMartens's avatar
TomMartens
Super User
5 years ago

Hey Anonymous ,

 

I have to admit that I have my difficulties to understand what you are tring to achieve.

 

Nevertheless, may this is what you are looking for.

I assume that your calendar table is called Calendar.

measure = 
var maxdate = max('calendar'[date]) // this returns the max date in the context of the slicer
return
CALCULATE(
 <here comes the numeric expression>
, DATESBETWEEN('calendar'[date] , maxdate - 90 + 1 , maxdate)
)

Hopefully, this provides what your are looking for.

 

Regards,
Tom

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Tom and thank you for replying.

 

Let me attempted to explain in more detail-

 

When I select a month from the left side radio buttons, I require (for example) the top right card to only show data that is >90 days from the month selected. 

 

The visual filter I have displayed works when there is only one month of data, but now that I have two months it does not work as the visual filter (CORP_LASTLOGONTIME) is fixed...

 

Regards,

Peter

 

 
 
 

  • TomMartens's avatar
    TomMartens
    Super User
    5 years ago

    Hey Anonymous ,

     

    it's still not clear, what you want to achieve.

     

    Please describe what has to happen when you select August 2020 from the leftmost slicer, what days have have to used to filter the measure(s) that you want to display on the card visuals.

     

    It's also not clear what you mean by the "visual level filter is fixed".

    Can you remove the visual level filter, and "just" rely on measure(s) that honor the month selection from the single-select slicer?

     

    Regards,

    Tom