Forum Discussion
Inactive relationship with calculated column.
Phil_Seamark I was able to create the measure using inactive relationship. but for the detail data i want 'salesaccountno' also in the tabular report. and same should filter using inactive relationship.
Now about the question why we have inactive relation ship:
Basically we dont want to give user two date(sales and order) in the filter pan. we only want to give them single date and based on the seletion on the slicer they can chose from sales or order date.
Every thing is working fine only problem i have with the detail data. how to show and filter them with inactive relationship.
Hi khajvd,
Actually, I don't think phil's solution will suitable for your requirement.
USERELATIONSHIP function is work in measures, it not real change relationships, so you will get correct result on measure and get wrong result on visuals.
FOr your scenario, you need to manual active and disable relationship to apply these filter effect on all related tables.
Regards,
Xiaoxin Sheng