Filtering data by measure and date picker

[Anonymous]

I have created a date picker using a slicer and selecting "After" in slicer and created a measure that takes the minimum value of the selected value in slicer.

So that I can get the data for that exact date.

When I check that measure in a card the date is being extracted as expected, but I want to know how I can filter the data in a table visual with that measure date.

Please help me out!!

@measurefilter

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

If you select "After" in slicer, you could use MIN function in the measure to filter.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Stephen Tao

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

If you select "After" in slicer, you could use MIN function in the measure to filter.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try to measure like

measure =
var _min = minx(allselected(Date), Date[Date])
return
calculate(sum(Table[value]), filter(Date, Date[Date] =_min))



measure =
var _max = maxx(allselected(Date), Date[Date])
return
calculate(sum(Table[value]), filter(Date, Date[Date] =_max))