Forecasting Issues

[lord_kaiser]

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

[Phil_Seamark]

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]

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]

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]

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]

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.

[lord_kaiser]

Hi Xi Jin,

Thank you for your response.

Please see link belo wregarding the pbix and sample file.

http://www.filedropper.com/sample_31

Regards,

Lord_Kaiser