Forum Discussion
Year over Year calculation Issue
Hi Anonymous
The issue here is that the legends (FY) you have used is slicing the value in your measure delta.
When you use the measure delta v/s months, their is no need of legend as you have already defined the logic as difference between Total spend of current and previous year.
If you also want to display the individual values whose delta is being calculated, pull in the measures CY Spend and PY Spend in the line chart. This should solve your issue.
Thanks,
Suguna.
Hi Anonymous
The issue here is that the legends (FY) you have used is slicing the value in your measure delta.
When you use the measure delta v/s months, their is no need of legend as you have already defined the logic as difference between Total spend of current and previous year.
If you also want to display the individual values whose delta is being calculated, pull in the measures CY Spend and PY Spend in the line chart. This should solve your issue.
Thanks,
Suguna.
Hi Suguna,
Thank you very much for the reply. After removing the legend it works. Could you kindly explain why the legend would screw my measure? And it's very strange that if I put filters on FY column instead of YOY, it also works.
So I have
CYSpend = CALCULATE([Total Spend], Inv_Period[FY] = 2018)
PYSpend = CALCULATE([Total Spend], Inv_Period[FY] =2017)
What's difference between them?
I guess I didn't describe clearly, so if I change my previous measures to these two, and keep everything else the same( still have FY as legends). The delta shows right answer on the chart. I mean the issue is solved and I'm just trying to understand more about PowerBI.
Anonymous