compare actual year vs precedent year with kpi

[coollehavre]

Hi i have three measures like that :

[Sum Sales]=SUM([Table Sales].Amount

[Sum Sales N-1] = CALCULATE([Sum Sales];SAMEPERIODLASTYEAR(Dates[Date]))

and a measure for goal sales : 

[Sum Sales Goal] = [Sum Sales N-1]*1.1

This measures works fine but i would like to show a KPI tha show the [Sum Sales] vs the [Sum Sales Goal]

So i added a KPI but when i select a year he shows nothing because theres no values in [Total Ventes Objectifs] (Sum Sales Goal)

How to have the sales for year selected and the sales for previous year when i select a year in my slicer ?

Thanks

[v-ljerr-msft]

Hi @coollehavre

According to your description above, I have tested it with my data. It turns out that your solution should work as expected.

Could share a sample pbix file which can reproduce the issue, so that we can further assist on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards