need a measure

[Anonymous]

Hi,

I needed two measures to know current year ranking and previous year ranking from the data below:

Country Name	Ranking	Year
India	12	2019
India	10	2020
US	2	2020
US	1	2019

Please help me to achieve this.

Thanks

[vanessafvg · Accepted solution]

CurrentYearRank = CALCULATE(sum(Countries[Ranking]), FILTER(Countries, Countries[Year] = year(today())))

PreviousYearRank = CALCULATE(sum(Countries[Ranking]), FILTER(Countries, Countries[Year] = year(today())-1))

This should work.

[az38]

Hi @Anonymous 

try

CurrentYear = CALCULATE(MAX(Table[Ranking]), Table[Year] = YEAR(TODAY()) )

and

PrevYear = CALCULATE(MAX(Table[Ranking]), Table[Year] = YEAR(TODAY())-1 )