Showing only Earlist date on each filed in matrix

[Anonymous]

I am trying to present the data in a matrix table, but when I input dates into the values field, it only displays the earliest date. It is not displaying individual fields with specific dates.

The third Warranty Period and so on is showing an incorrect date (07-Feb-2022) on all fields when it should be different for each field. Is there a solution to this issue that would enable the correct values to be displayed

ATM matrix table showing me like this

I need like this

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

Based on your description and the screenshots provided, do you want to get the minimum date under different levels under different levels?
If so, you can use the isinscope() function to determine which level you currently belong to to to return different values. The values you need to calculate depend on your filter context, and if you want to ignore filtering at a certain level, you can use calculate([measure],allselected('Table' [column names at this level]))).

For more information, you can refer to :
ISINSCOPE function (DAX) - DAX | Microsoft Learn

ALLSELECTED function (DAX) - DAX | Microsoft Learn

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[amitchandak]

@Anonymous , Measure like

MAx(Table[date])

or

calculate(max(Table[Date]), allselected(Table[Column]) )

[Anonymous]

Still not showing me the correct values
Could you please which column i used here

allselected(Table[Column]) )