topic Need help with Filter Context Issue in DAX Commands and Tips

Need help with Filter Context Issue

Anonymous — Mon, 28 Aug 2023 16:44:21 GMT

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

Re: Need help with Filter Context Issue

some_bih — Sun, 03 Sep 2023 20:48:49 GMT

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

After choose active relationship

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