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 some reason it shows me all the months and years (See screen shot)

 

 

 

Forecast Revenue = CALCULATE([Forecaster],FILTER(Clients,Clients[Acquisition]<>""))

 

Actual Revenue = [Total Revenue]-[Excluded Revenue]
ABS Variance = ABS([Actual Revenue]-[Forecast Revenue])
Bias = [Actual Revenue]/[Forecast Revenue]

 

Forecast Accuracy = 1-([ABS Variance]/CALCULATE([Forecast Revenue]))

Any idea on how i can resolve this?

 

Thanks

 

Need Help

6 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    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's avatar
      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'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.