Need to show all months even if sales hasnt happened to show future forecasting

[#1]

Hi,

I am new here I have already created a data model. and the required table in tab sheet 7 and it's all correct

There are two scenarios first either I get the Item Name into the table and show forecast for all items or I can get a filter selection of the item. But none works When you select a filter the forecast month goes to null.

Please take a look at the attached file and let me know if there is any solutions for both the scenarios.

[sunny_talwar]

Not sure if you would want to ignore selection in all fields or some of the fields... but as an example using {1} in your abc expression make Forecast fixed regardless of any selection

(sum({1}[Sale Qty])/((sum({1}[Sale Value])/sum({1} DISTINCT Stores)/sum({1} DISTINCT day)/100000) * sum({1} DISTINCTSeasonality)*sum({1} DISTINCT day)/sum({1} DISTINCT [Promotion Factor])))