Forum Discussion
Selectedvalue and Userelationship in the table
Community Champion
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
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.
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] ) )