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 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?

DAX
SELECTEDVALUE
USERELATIONSHIP

4 Replies

    • Vialle_Diego's avatar
      Vialle_Diego
      Frequent Visitor
      3 years ago

      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'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.