Need help with Filter Context Issue

[Anonymous]

Hello, 

I'm having an issue with the Expired and Cancel measures in my model. The 1 indicator only shows up when I select a customer’s Location SK in the slicer. I want it to appear regardless of the selection, but I’m not sure how to handle the filters. Any help would be appreciated.

V2 Expired works when selecting an individual Location SK

But it doesn't work when I don't have an individual Location SK selected

PBIX File Link

[some_bih · Accepted solution]

Hi @Anonymous put you relationship for table Calendar and Service Agreement as active and properly write 'Calendar' in your measure.After that number should be visible.

Did I answer correctly? Kudos appreciate / accept solution.

Before changing relationship to active

 TO

After choose active relationship

In slicer Location Sk-Copy (why Copy when in SUMMARIZE THERE ARE no copy)