Forum Discussion
Solved
Custom Filter
Hello all, hope you all doing good. I have created 2 measures to show the opening and the closing of the month by selecting the month in slicer. Those measures are, Measure 1 = IF(MAX('Final...
Ibadkhan , Based on what I got try like
measure =
var _min = minx(allselected('Date'), 'Date'[Date])
var _max = maxx(allselected('Date'), 'Date'[Date])
return
CALCULATE(sum('Final Data Sheet'[Purchase]), FILTER(('Final Data Sheet'),'Final Data Sheet'[invm_Date] >= _min && 'Final Data Sheet'[invm_Date] <=_max))
Ibadkhan , Based on what I got try like
measure =
var _min = minx(allselected('Date'), 'Date'[Date])
var _max = maxx(allselected('Date'), 'Date'[Date])
return
CALCULATE(sum('Final Data Sheet'[Purchase]), FILTER(('Final Data Sheet'),'Final Data Sheet'[invm_Date] >= _min && 'Final Data Sheet'[invm_Date] <=_max))
amitchandak one more thing, can i use measure instead of column for purchase?
