Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

need a measure

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...
Need Help
  • vanessafvg's avatar
    vanessafvg
    6 years ago
    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.
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
6 years ago
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.