Forum Discussion

Elie_HUCHET's avatar
Elie_HUCHET
Helper III
2 years ago

Filter management problem

Good morning, I allow myself to contact you because I have a problem concerning filters. As you can see here I have an array of values ​​from measurements. These measurements make it possible to ca...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

Elie_HUCHET , when you select a month and want to display a range more than that. You need disconnected date table for slicer

 

example

 

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -3) +1
return
calculate( sum(sales[Gross Sales]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

 

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

  • Elie_HUCHET's avatar
    Elie_HUCHET
    Helper III
    2 years ago

    Thank u for your help 🙂

    But I got a problem with the measure:

    3 Derniers Mois =
    VAR DateMax = maxx(allselected(Calendrier),Calendrier[Calendrier])
    VAR DateMin = EOMONTH(DateMax, -3) + 1
    RETURN
        FILTER('calendrier', 'calendrier'[calendrier] >= DateMin && 'calendrier'[calendrier] <= DateMax)

    But I don't understand why? Can you help me?

    Have a nice day