Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |