Stacked with Slicer Filter

[George1973]

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 · Accepted solution]

@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]

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!