Hi there. This is my first post in this forum. I have been studying a lot DAX recently using the resources of enterprise DNA, but I got stuck with the below:
I was able to accomplish in Power Pivot a PL with sub-totals, which was really nice victory.
But when I inserted a slicer for the profit center, there no value in my forecast measure. Measure for actuals is ok. See below.
I tried everything and cant make this work. Below are my data model.
And a summary of my measures.
Any idea why the forecast measure is not being picked up by the slicer?
Any help is much appreciated.