topic Re: Stacked with Slicer Filter in DAX Commands and Tips

Stacked with Slicer Filter

George1973 — Tue, 19 Jul 2022 09:29:48 GMT

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,

Re: Stacked with Slicer Filter

amitchandak — Tue, 19 Jul 2022 12:21:34 GMT

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

Re: Stacked with Slicer Filter

George1973 — Tue, 26 Jul 2022 18:37:49 GMT

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!