Forum Discussion

Vialle_Diego's avatar
Vialle_Diego
Frequent Visitor
3 years ago

Selectedvalue and Userelationship in the table

The status "Em andamento" does not have "Data de conclusão". So I created an inactive relationship of the dcalendario with the column "Data de Solicitação" and now I am trying to force through the fo...
DAX
SELECTEDVALUE
USERELATIONSHIP
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Vialle_Diego 

Sometimes USERELATIONSHIP doesn't work by itself. You need to have CROSSFILTER- NONE along with it to deactivate the activate relationship and then USERELATIONSHIP will activate the inactive relationship. 

Vialle_Diego's avatar
Vialle_Diego
Frequent Visitor
3 years ago

I tried to do it as follows, first create a measure for the lines with status "Em andamento". In the sequence I created the measure to disable the relationship of the column "Data de conclusão" and the dCalendar. And finally I used Userrelationship to force the relationship of "Data de solicitação" and dCalendar. Did I do something wrong?
The Status column for "Em andamento" continues to obey the dCalendar filter (which is related to the Data de conclusão)

Contratações em Andamento = 
CALCULATE (
    DISTINCTCOUNT ( fBase[Índice] ),
    FILTER ( fBase, fBase[Status] = "Em andamento" )
)

 

STATUS EM ANDAMENTO = 
CALCULATE (
    [Contratações em Andamento],
    CROSSFILTER ( fBase[Data de conclusão], dCalendario[Data], NONE ),
    USERELATIONSHIP ( fBase[Data da solicitação], dCalendario[Data] )
)