Forum Discussion
slicer distant relationship
Hello, I have a measure that is summing up values in table PROJETOSEGMENTO, and I want to use a slicer so that my measures sums by department. But the relationship between the two tables isn'...
If you want to use a slicer which can slice the PROJETOSEGMENTO measure with Department, you must have active relationship between these tables. It must have a path from Department to PROJETOSEGMENTO.
If you just need to slice the measure in DAX, you can use USERELATIONSHIP() to use inactive relationship for your calculation.
Regards,
Yes, I am using a DAX expression, my problem with USERELATIONSHIP is that I have a series of relationships I need it to consider, so should I use:
USERELATIONSHIP(Department[code];Servprod[codigodepartament];servprod[id];tipoprojeto[servprod_id]) USERELATIONSHIP(Department[code];Servprod[codigodepartament]); USERELATIONSHIP(;servprod[id];tipoprojeto[servprod_id]) ETC....