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...
Hi aanchalsharma18 ,
Can you try :
UnengagedDoctorsByTerritory =
CALCULATE(
COUNTROWS(Doctors),
NOT(COUNTROWS(Call) > 0),
TREATAS(
VALUES(Territory_Hierarchy[Name]),
REL_Doctor_Territory[Territory_ID]
)
)
Hope this helps!