Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need help with Filter Context Issue

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

 

 

 

DAX
Filter context
  • some_bih's avatar
    some_bih
    3 years ago

    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)

     

1 Reply

  • some_bih's avatar
    some_bih
    Community Champion
    3 years ago

    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)