KPI when selection vs selection -1 year

[hansvillo]

Hello,

I have a KPI with two measures. The first measure is:

if(GetSelectedCount(MonthYear) = 0, count({<RY = {'1'}>}DISTINCT _Debtor) , count(DISTINCT _Debtor))

The second:

if(GetSelectedCount(MonthYear) = 0, count({<LRY = {'1'}>}DISTINCT _Debtor) , count(DISTINCT _Debtor))

So by default, the KPI show Rolling year vs Last Rolling Year. In Red is when you make a selection on Monthyear.

Now: When I Select May-2019

The first measure is showing 2k and the second shows 2k also.

I want the second measure to show the selected date -1 year. Somehow I don't get it right. (and I think its simple 🙂 )

Does someone know the answer? Thx

[Anil_Babu_Samineni · Accepted solution]

Second Measure

if(GetSelectedCount(MonthYear) = 0, count({<LRY = {'1'}>}DISTINCT _Debtor) , count({<Month_Year = {"$(=AddYears(Max(Month_Year),-1))"}>} DISTINCT _Debtor))