How do i slice this measure?

[MrJoosten]

Hello guys,

I've got a measure that works perfectly. The only downside is, I cant use my slicer(s).

This is the code I've got so far:

Cumulative line ACT 2017 = 
          Calculate(
              SUM(DATA[ACT 2017])
              FILTER(
    ALL(
         (DATA));DATA[DATE] <= MAX(DATA[DATE]));DATA[ACT 2017] > 0 
)

The slicer works for the variables on the (DATA) table. But I want to be able to slice a connected table called: "SOLD TO TABLE".
On the SOLD TO TABLE are my customers and its important that I can filter on those.


Thanks for any advice!

Kind regards,
Peter

 

[gazpage]

I'm a little surprise slicers work on this measure because you are filtering over the whole table using ALL(). Can you slice columns other than [Date]?

I would suggest switching ALL() to ALLSELECTED() or ALL(DATA) to ALL(DATE[DATE]).

 

[MrJoosten]

Thanks a lot Gaz, Allselected was the key!

Hope this helps other people too!