Custom Filter

[Ibadkhan]

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 Data Sheet'[invm_Date])<=EOMONTH(MAX(Dates[Date]),0),1)

Measure 2 = IF(MAX('Final Data Sheet'[invm_Date])<=EOMONTH(MAX(Dates[Date]),-1),1)

This solution was provided by community memeber, link is here, 

https://community.powerbi.com/t5/Translated-Spanish-Desktop/Filtro-personalizado/m-p/1877629#M245617

Now i want show the purchases of the the month with opening and closing selected in filter.

Is there any solution?

Thans In Advance

@Icey  @amitchandak 

[amitchandak · Accepted solution]

@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]

@amitchandak  one more thing, can i use measure instead of column for purchase?

[Ibadkhan]

Thanks alot @amitchandak . It is working perfectly...

You really made my day... 🙂 🙂