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:
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
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:
Code:
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