Just to paint a background on what I’m trying to achieve here.
I’ve got a set of financial statements with 3 year historical numbers with I’ve set up into the income statement template and I have a set of assumptions that for future projections.
Currently, I’ve got no issues with setting up the historical financial statements in the canvas and the numbers appearing are correct.
However, when I look to add the future projections, I cant seem to get the numbers to appear in the correctly and in the correct location.
Your WTA Line Item Actual measure is working exactly as intended. The problem is with your FY Revenue Forecast measure. In testing the former, I set the latter just equal to 100 and the WTA measure returned the expected/correct results:
Tracing through your FY Revenue Forecast measure, that measure is returning the value of the variable FillRateBestCase. I would suggest working through the three filter conditions in that variable to figure out why they are returning a blank table.
These 2 tables are connected via the dates table, however, the “year end” column that I was using to connect to the dates table was in text format resulting in an improper connection.
After fixing changing the format to date, then the calculations flows over to the WTA table.
Thanks very much for the update - really glad you were able to get to a good solution.
It’s a great reminder that anytime someone says “my DAX isn’t working”, it’s a good idea to look to the data model first. The DAX itself may be absolutely fine (as it was in your case), but still returning incorrect results becauses of problems w/ the data model istelf.