Forum Discussion
USERELATIONSHIP Issue
Thanks 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.
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