Forum Discussion
Solved
SelectedValue and Dates
Hello, I'm trying to make a report that shows the stock size, prize and total value of different items. I need to tell the total value using different approaches: Value when bought, Value of the ...
Could you just leave out the ALL( 'Date'[Date] ) of the "Last Selling Value" measure.
This is an explicit filter context which prevents the slicer filter from filtering your dates.
timalbers
Skilled Sharer
Skilled SharerCould you just leave out the ALL( 'Date'[Date] ) of the "Last Selling Value" measure.
This is an explicit filter context which prevents the slicer filter from filtering your dates.
It works for every product we sold that day, but for those we haven't it gives blank back.
edit: I got it, I just had to replace the Invoice to Depot in the Summarize.