Forum Discussion
Solved
Calculate function filter doesnt seem to work
Hi everyone, I have a little filter problem. I think i dont really understand how the calculate function works. The objectif is to change the selected value of the sales in a slicer, t...
Hi YannDV ,
Your problem is this part of the Simulated Sales measure:
ALL('Final Product Master Data'[Article])
This is telling DAX to remove all filters on the data when calculating, including the filters applied by your slicers.
Try this instead:
Simulated Sales = [Sales] * 'Parameter Simulation Sales'[Parameter Simulation Sales Value]Pete
Hi YannDV ,
Your problem is this part of the Simulated Sales measure:
ALL('Final Product Master Data'[Article])
This is telling DAX to remove all filters on the data when calculating, including the filters applied by your slicers.
Try this instead:
Simulated Sales = [Sales] * 'Parameter Simulation Sales'[Parameter Simulation Sales Value]
Pete