Tricky measure with dax

Hi Meca2u ,

You can this calculation :-

Column = CALCULATE(MIN(Table1[Value]),FILTER(Table1,Table1[Country]=EARLIER(Table1[Country]) && Table1[State] =EARLIER(Table1[State]) && Table1[Color] =EARLIER(Table1[Color]))))

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

Hi Meca2u  ,

 

Please follow these steps:

1.Create metrics that return the smallest value for the smallest date after sorting by country, state, and color.

 

Denominator = 
var _min_period=
MINX(
    FILTER(ALLSELECTED('Table'),'Table'[Country] = MAX('Table'[Country]) && 'Table'[State] = MAX('Table'[State]) && 'Table'[Colour] = MAX('Table'[Colour])),
    'Table'[Period])
var _min_value=
MINX(
    FILTER(ALLSELECTED('Table'),'Table'[Country] = MAX('Table'[Country]) && 'Table'[State] = MAX('Table'[State]) &&'Table'[Period]=_min_period),[Value])
return
IF(
    MAX('Table'[Period])=_min_period&&MAX('Table'[Value])=_min_value,_min_value,BLANK())

 

2.The results obtained are as follows.

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

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