Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |