min in each category to be subtracted from actual values for every other category

[ShaRaj]

hi, Iam learning dax .kindly help me in solving -

how can i substract these minimum of each "value" corrsponding to "category"  for each "country".

like .

for each Country - for "p" category - value minus minmum(P)

fact table

Thank you

[wdx223_Daniel · Accepted solution]

NewColumn=TableName[Value]-MINX(FILTER(TableName,TableName[Year]=Earlier(TableName[Year])&&TableName[Category]=Earlier(TableName[Category])),TableName[Value])