Forum Discussion
Implementing slicer selection on a table visual where the source tables are having inactive relation
In my dashboard I am having 1 fact table called "Call" and 3 dimension tables namely, Doctors, Territory and Rel_Doctor_Territory in DIRECT QUERY mode.. As per the attached screenshot Doctors...
Create a measure like
Doctor is not engaged =
VAR CalledDoctors =
CALCULATETABLE ( DISTINCT ( Call[DoctorID] ), REMOVEFILTERS ( Territory ) )
VAR DoctorsInTerritory =
CALCULATETABLE (
VALUES ( Doctors[DoctorID] ),
USERELATIONSHIP ( Territory[TerritoryID], REL_Doctors_Territory[TerritoryID] )
)
VAR UnengagedDoctors =
EXCEPT ( DoctorsInTerritory, CalledDoctors )
VAR Result =
IF ( SELECTEDVALUE ( Doctors[DoctorID] ) IN UnengagedDoctors, 1 )
RETURN
Result
Add this as a filter to a table or matrix containing Doctors[DoctorID] and set it to show only when the value is 1.
Thanks for your help but I am still not able to filter the data on the basis of terrirtory name in my report.
Can you share a PBIX with any confidential information removed or anonymised ? You can post a link to e.g. Google Drive, OneDrive etc.
