Forum Discussion
Calculation at different granularity: Demand Planning
Hi v-ljerr-msft,
Thank you for the response. And yes, you understood it correctly. That is what I am trying to achieve, but the hard part I don't understand is calculating the ForacastAccuracy at different levels.
For ex:
| Plant | Customer | Material | Actauls | Forecast | ForecastAccuracy |
| 1 | 1 | 1 | 100 | 110 | 0.909090909 |
| 1 | 2 | 1 | 120 | 150 | 0.8 |
| 2 | 1 | 1 | 50 | 60 | 0.833333333 |
| 3 | 2 | 1 | 60 | 50 | 1.2 |
If I want my ForecastAccuracy formula to execute at plant-customer-material, I will get the above results
Next, at Customer-Material level, I should get:
| Customer | Material | ForecastAccuracy | ||
| 1 | 1 | 150 | 170 | 0.882352941 |
| 2 | 1 | 180 | 200 | 0.9 |
So, by selecting the slicers from the parametter table(Data level), I can have my chart display ForecastAccuracy for different granularity.
I don't understand how to write the dax for these different level of data. Does this make sense?
Hi Anonymous,
As there is no any option to dynamically show/hide columns on Table/Matrix based on Slicers currently, I don't think there is way to do it in your scenario. :smileyhappy:
Regards