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...
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)

     

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)