Forum Discussion

setis's avatar
setis
Post Partisan
7 years ago
Solved

Slicing through inactive relationship

I have a table for [Cases] and another one for [Payments].   These tables are joined through CaseID by an innactive relationship that has to remain inactive.   I need to slice a chart with data f...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    setis

     

    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.  

AlB's avatar
AlB
Community Champion
7 years ago

setis

 

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.  

Garridex's avatar
Garridex
Regular Visitor
6 years ago

I recommend:

 

Calendar2 = ALL(Calendar)

 

cheers!