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 the slicer for other purposes. So I'm trying to neglate (ignor) it in the relevant measures, but it DOES NOT WORK!!!

Total WIP Prod Qnty =
calculate (sum(FMG_SAQGZA[DARCHRAOD]),
FILTER(FMG_SAQGZA,FMG_SAQGZA[IP$FLAGS]<>4099),

ALL(DateKey))


- "All" does not work..

Total WIP Prod Qnty =
calculate (sum(FMG_SAQGZA[DARCHRAOD]),
FILTER(FMG_SAQGZA,FMG_SAQGZA[IP$FLAGS]<>4099),

REMOVEFILTERS(DateKey))



- Removefilters - Does not work neather


So, I'm going mad spet by step!

There are no date filters on the general filter panel as well.

So, can you give me some hints, why I could be like that?

Thanks in advance,


  • 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

2 Replies

  • 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!