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
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)
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)
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 13 | |
| 9 | |
| 8 | |
| 5 | |
| 5 |
