Slicer not working for one measure

DAX DAX Calculations
1

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:

image
image712×522 14 KB

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.

image
image792×474 14.4 KB

I tried everything and cant make this work. Below are my data model.

image
image1115×484 25.6 KB

And a summary of my measures.

image
image1214×201 7.88 KB

Any idea why the forecast measure is not being picked up by the slicer?

Any help is much appreciated.
Thanks,
Ageber

2

Can you attach the file? reading unformatted DAX code uses all the cores of my brain and then I get nauseous.

Also I see VALUES inside CALCULATE filter argument being used in a predicate, this will break the report in future if not doing right now.

4

I see at some cells the slicer is working but you are creating a filter context with slicer and then checking for this condition that’s why your forecast measure is not working.Area 3200 2020.xlsx (1.6 MB)

=
AND (
    ISFILTERED ( 'Chart O fAccounts'[SubHeader] ) = TRUE (),
    MAX ( Headers[Sub-total?] ) = 1
)
5

Many thanks, mate.

Two little things that I cant get my head around yet: 1) Not sure why it works for the Actuals but not the forecast, if the measures are the same for both; and 2) How to fix this.

I will keep digging.

Regards,
Alex

6

@ageber, @AntrikshSharma In that file the relationship between Profit Center table and Forecast table was on the wrong column, Vessel Name, instead of Profit Center. When I corrected it, the issue was resolved.

7

Many thanks, @datazoe!

I knew it was something easy that was off. Lesson learned about the importance of setting up relationships correctly.
Regards,
Alex

8

@ageber The only reason I know to check is I’ve done it myself so many times! :slight_smile: Glad it’s all sorted now.