max selected value of slicer and remove filters

[Discovery]

Good afternoon,

I had this working yesterday, and today I cannot seem to find my calculation. It seems simple, but not working.

I am trying to capture the max and min date of a date slicer regardless of another filter chosen in the table. The inventory slicer is coming from the same filter as the date, but I want to disregard that filter, and have a static variable for first and last date of the date range.

There are no other filters selected  to affect this.. 

I did MinDateSelected

CALCULATE(

Min('Total Inventory Received'[Date] ),

ALLSELECTED( 'Total Inventory Received'[Date] ),all('Total Inventory Received'[InventoryID]))

but it is not disregarding the inventory filter

[v-kkf-msft · Accepted solution]

Hi @Discovery ，

Could you please share your example data? Here is the example I created based on your formula, the measure returns the correct value: 1/10/2021, which corresponds to an InventoryID of C and is not affected by the InventoryID slicer.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz

[VahidDM]

HI @Discovery 

Try this:
MIN = 

CALCULATE (
    MIN ( 'Total Inventory Received'[Date] ),
    ALLEXCEPT ( 'Total Inventory Received', 'Total Inventory Received'[Date] )
)

MAX = 
CALCULATE (
    MAX( 'Total Inventory Received'[Date] ),
    ALLEXCEPT ( 'Total Inventory Received', 'Total Inventory Received'[Date] )
)

https://docs.microsoft.com/en-us/dax/allexcept-function-dax

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/