Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm calculating order on hand (order backlog) show the resuslt in the same visual for diffrent departments. It works well if I don't filter the result using 'cDepName' slicer, but as soon as I select a diffrent department the calculation result shows blank.
visual if slicer cDepName = all
visual if slicer cDepName = any other selection
Dax1: Order Income Cumulative = CALCULATE([Order Income],'date'[Date] <= MAX ('date'[Date]))
Dax2: Turnover Cumulative = CALCULATE([Turnover],'date'[Date] <= MAX ('date'[Date]))
@Greg_Deckler it's a multi table data model. Order income, Turnover and Department are in diffrent tables.
@Joern Maybe try something like this:
Order Income Cumulative =
VAR __MaxDate = MAX ('date'[Date])
VAR __Result = CALCULATE([Order Income], ALL('date'), 'date'[Date] <= MAX ('date'[Date]))
RETURN
__Result
or
Order Income Cumulative =
VAR __MaxDate = MAX ('date'[Date])
VAR __Result = CALCULATE([Order Income], ALLSELECTED('date'), 'date'[Date] <= MAX ('date'[Date]))
RETURN
__Result
@Greg_Deckler I tried both your ideas, but result is still the same. However I'm not sure what your 1st variable MaxDate does, as it seems not to be used later on in your DAX?
Order Income Cumulative = VAR __MaxDate = MAX ('date'[Date]) VAR __Result = CALCULATE([Order Income], ALL('date'), 'date'[Date] <= MAX ('date'[Date])) RETURN __Result
If I filter department inside my calculate function I get the result for each department, but it's not as nice as using the slicer... 😞 I can use it as a workaround, but still prefer to get the slicer working.
@Joern Difficult to say. Is this a single table data model? If so you could be running afoul of Auto Exist.