Forum Discussion
Post PartisanSlicing through inactive relationship
How about you create a second calendar table, copy of the one you have,
Calendar2 = Calendar
and create an active relationship between Calendar2[Date] and Payments[Incident date]? Then you work with that Calendar2 in this particular dashboard. Make sure there are no filters on the original 'Calendar' on that dashboard.
Otherwise you'll have to create specific measures including USERELATIONSHIP( ) for all cases.
Community ChampionHi setis
I'm not sure I understand completely what you are trying to do. I mean I don't get what purpose it would serve to filter the table visual like that but well... I'm quite tired and slow today :smileyindifferent:
You can create a measure like this:
FilterMeasure = IF(SELECTEDVALUE(Payments[Ref]) IN DISTINCT('Cases'[Ref]);1)and place it in the visual level filters of the table visual you have in the report. Then select to 'Show items when value is -->1'
The slicers on 'Cases'[Incident Date] and 'Cases'[Case Type] will then have an effect on the table visual. You'd need to have Payments[Ref] in the rows of the table visual for this to work properly.
If you want to use measures that leverage the inactive relationship between Calendar and payments you'd probably want to use USERELATIONSHIP( ) but like I said earlier we would need to know the exact details to know how to approach it.
Post PartisanHi AlB,
The measure works perfect. Thanks!
Apologies if I didn't explain the calendar issue properly.
As you can see here:
The active relationship "Date"-"Posting date" is the one that I'm using in the rest of the report. However, the table payments captures another data point that tell us when the incident that we are paying for, occurred.
I need to be able to use a slicer to filter all the visuals on a page related to the table Payments but using the innactive relationship "Date"-"Incident Date". Is there a way to do it whithout changing the status of these 2 relationships?
- AlB
How about you create a second calendar table, copy of the one you have,
Calendar2 = Calendar
and create an active relationship between Calendar2[Date] and Payments[Incident date]? Then you work with that Calendar2 in this particular dashboard. Make sure there are no filters on the original 'Calendar' on that dashboard.
Otherwise you'll have to create specific measures including USERELATIONSHIP( ) for all cases.
