Selectedvalue and Userelationship in the table

[Vialle_Diego]

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 formula below the purchases with status "Em andamento" to appear according to the dcalendario filter, but it is not working. Where am I wrong?

Status da Compra = 
CALCULATE (
    SELECTEDVALUE(fBase[Status], "Em andamento"),
    USERELATIONSHIP ( fBase[Data da solicitação], dCalendario[Data])
)

after selecting 2022 in the filter, purchases with status "In progress" are removed.

@tamerj1  Do you have any idea where I'm going wrong?

[tamerj1]

@Vialle_Diego 

Hello friend 

Try to CROSSFILTER the other relationship to NONE

[Vialle_Diego]

Hey friend, nice to talk to you again!
So I read the documentation about the crossfilter, but I don't think it's what I need.

I need the "Data de Solicitação" column to respect the dcalendar filter for the "Em andamento" filter.

[tamerj1]

@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]

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] )
)