Slicer not filtering DAX measure required for navigation

[Aicyss]

Hi! 
I am quite new to Power BI and DAX and I'd appreciate if you could help with an issue I have! 

I created a measure which is intended to be used for navigation, the idea is that if an indicator meets certain criteria it will take you to page 1, if it meets a different criteria it takes you to page 2, etc. The measure works well when I have just a list of all the indicators on my table visual, but if I add the department that owns each of those indicators, the measure stops working. There might be something wrong with the model or the measure needs some context changing code, I have no idea, so any help will be welcome!

This is the measure: 

KPI Navigation = 
VAR frequency = SELECTEDVALUE(DIM_KPIAlignment[Frequency])
VAR datatype = SELECTEDVALUE(DIM_KPIAlignment[Type])
VAR annualtype = SELECTEDVALUE(DIM_KPIAlignment[AnnualType])

RETURN
    IF(
      frequency = "Annually" && datatype = "Percentage" && annualtype = Academic",
            "Page 1",
     IF(
      frequency = "Monthly" && datatype = "Number" && annualtype = "Academic",
                "Page 2",
     IF(
      frequency = "Annually" && datatype = "Number" && annualtype = "No",
          "Page 3",
                    "Page 4" 
                )
            )
        )

This is the data model (the images tables and the targets table are just there temporarily, they're not part of the model itself): 

Service table is join to KPI alignment using the service code, and one of the columns in the service table is directorate name, this is what I am using on the table visuals below. 

This is the result: 
As you can see, the indicators repeat themselves for each department, which is wrong, and the KPI navigation measure shows the right result only for the indicator within the right department (for example, number 9 is in Ed & Children and it definitely goes to Page 1 :

This is the expected result, but showing the name of the directorate, instead of the code that connects the KPI Alignment table with the Service table:

 Thank you in advance for any help you can provide!

[Aicyss]

Hi! 
As I was preparing the sample data to share I realised that the issue was that the setting on the report had been changed to disable filtering and cross highlighting.
Thanks!

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...