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.
Good Afternoon,
There must be an obvious reason but I cannot fathom it out. I am trying to include a KPI visual which compares YTD sales figures with Previous YTD sales, but I get and empty comparison.
Here is the screenshot:
The two boxes underneath are the measure reflecting both current and previous year YTD sales numbers.
The trend axis is "year".
Any pointers??
Thank you very much for your help!
regards
Paul.
Proud to be a Super User!
Paul on Linkedin.
Solved! Go to Solution.
Thanks for sharing the pbix. Add ALL to the filter to exclude any filter context.
Sales YTD = calculate(sum('Campañas2'[Facturación Real]), Filter(ALL(YearMonth), YearMonth[month]<= MONTH(TODAY()) && YearMonth[year]=YEAR(TODAY()) )) Sales MonthTD Previous Year = calculate(sum('Campañas2'[Facturación Real]), Filter(ALL(YearMonth), YearMonth[month]= MONTH(TODAY()) && YearMonth[year]=YEAR(TODAY())-1 ))
Sure I can share a sample pbix file? How do I share it though??
Proud to be a Super User!
Paul on Linkedin.
You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.
Here it is:
Proud to be a Super User!
Paul on Linkedin.
Thanks for sharing the pbix. Add ALL to the filter to exclude any filter context.
Sales YTD = calculate(sum('Campañas2'[Facturación Real]), Filter(ALL(YearMonth), YearMonth[month]<= MONTH(TODAY()) && YearMonth[year]=YEAR(TODAY()) )) Sales MonthTD Previous Year = calculate(sum('Campañas2'[Facturación Real]), Filter(ALL(YearMonth), YearMonth[month]= MONTH(TODAY()) && YearMonth[year]=YEAR(TODAY())-1 ))
Thanks you!!!
You're an absolute star!
(I only wish I understood why addin "ALL" is necessary though...)
Best regards,
Paul.
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |