Forum Discussion

George1973's avatar
George1973
Icon for Helper V rankHelper V
4 years ago
Solved

Stacked with Slicer Filter

Hi Guys, On the dashboard given below, date slicer does not allow mesures work properly for some reason: When I completely remove the slicer, then the figures work fine: But I need ...
  • amitchandak's avatar
    amitchandak
    4 years ago

    George1973 , if you are using date in the visual all/removefilters might give the desired result. In that case use an independent date table and filter the data when required in a measure

     

     

    //Date1 is independent Date table
    new measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    var _min = minx(allselected(Date1),Date1[Date])
    return
    calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

     

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

    Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

George1973 , if you are using date in the visual all/removefilters might give the desired result. In that case use an independent date table and filter the data when required in a measure

 

 

//Date1 is independent Date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

 

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

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

George1973's avatar
George1973
Icon for Helper V rankHelper V
4 years ago

Dear amitchandak ,

Thanks a lot for the idea. Soory for beeing late with the answer.
I have tried the suggested solution but it did not work - the measure I mean, BUT what WORKED and helped me with the whole solution, was the idea about independed CLONE DATE TABE. I have implemented it fully, re_worked all the time inteligence measures and it gave me the true results!
So, thanks a lot once again!