I used this and it works..
@CJ_96601 Please update your Measure logic as below and use your Year field as a filter.
Test219 = VAR _Total = SUMX(SUMMARIZE(Test219MaxSum,Test219MaxSum[BadgeNo],Test219MaxSum[Year],"Amount",MAX(Test219MaxSum[Amount])),[Amount]) RETURN IF(HASONEFILTER(Test219MaxSum[Year]),SUMX(DISTINCT(Test219MaxSum[BadgeNo]),CALCULATE(MAXX(Test219MaxSum,Test219MaxSum[Amount]))),_Total)
Hi, thank you for your response.
The date (year) i am currently using is in another table.
Do i need to make a relationship between the two tables.
As of now, there is only one active relationship in power bi
Furthermore, if i make a relationship (Year), if i click year 2020, the result is zero , null, as there is no record in 2020. What i would like to have is to have 2019 sum even if i click 2020.