Forum Discussion

lord_kaiser's avatar
lord_kaiser
Helper I
8 years ago

Forecasting Issues

Hi Everyone,   I seeem to be having an issue with checking the forecast accuracy.   When i select a financial year, i only want it to show the forcast accuracy for that financial year. But for so...
Need Help
v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi lord_kaiser,

 

=> The year column in the grid is going by the dates from the dates table and the slicer is going by the Financial year from the dates table. 

 

So the year column in the grid is different with the year in slicer. One is year from Date and one is the Financial year. Right?

 

To troubleshoot your issue, try to use the same year column both in grid and slicer.

 

Thanks,
Xi Jin.

lord_kaiser's avatar
lord_kaiser
Helper I
8 years ago

Hi Xi Jin,

 

Thanks for your response.

 

I have another report that has the year field in the table and the FY in the slicer and i have no issues with displaying the visual.

 

The issue only happens when i add the forecast accuracy calulated measure to the table. I feel this may be caused by not iterating? need some help with just that dax expression

 

thanks

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    Hi lord_kaiser,

     

    Could you please share us some sample data which can help us repro your issue and make some tests if possible?

     

    Also, if you can share us your pbix file. It will be more helpful.

     

    Thanks,
    Xi Jin.