Forum Discussion

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...

Microsoft Employee

8 years ago

Is the year column in the grid the same as the one you use in your slicer? And do you have all relevant relationships setup?

lord_kaiser
Helper I
8 years ago
Hi Phil,

Thanks for the quick response.

I have a 1 to many relationship from my dates table to the master commissions table.

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.

Dates Table:

Master Transactions Table:
- 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
    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