Forum Discussion
Helper IUSERELATIONSHIP Issue
Super UserHi Oliver_Buchanan ,
- Check cross filter direction of 'Action'[CollectionActionEventKey] and 'ActionEvent'[ActionEventKey]
- If its not possible to change it permanently, then change cross filter direction using below DAX example.
CollectionActionEventTimeuse =
CALCULATE (
MAX ( 'ActionEvent'[Created] ),
CROSSFILTER ( 'Action'[CollectionActionEventKey], 'ActionEvent'[ActionEventKey], BOTH )
)I have given example of both cross filter direction you can change and try accordingly.
Please give kudos or mark it as solution once confirmed.
Thanks and Regards,
Praful
Helper IThanks for the suggestion, i had tried changing the relationship to both ways already, i hadn't tried using crossfilter in the measure itself.
Unfortunately neither of these methods fix the issue.
The CollectionActionEventTime column in the 'Action' table below is the measure using TREATAS and it is pulling the correct value from the ActionEventTable.
The CollectionActionEventTimeuse in the below screenshot is using your suggested measure, but as you can see its still producing the same result it has this whole time. Which is the MAX from the whole set. This is the value it should produce when using the active relationship, but specifically USERELATIONSHIP should ignore the active relationship.
- Oliver_Buchanan
FYI ActionEventKey is distinct for those rows, PowerBi in the visual just struggles to show the full 64 bit integer value. ie see below screenshot
- Bmejia
Hi Oliver,
is it possible that your created column is not of a date and time format. That could be causing the issues that you have it format as text. cause i notice you have p.m. and a.m. usually is capitalized with no puntuation.