Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
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] )
)
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |