Forum Discussion
Helper ICross filter direction with concatenatex
Hi,
I have FactTable with Activities, then I have bridge table to Users, as there can be multiples users in 1 Activity (appointment). I know, that using both direction filtering is not recommended. But, I have a table visual, where I want to concatenate Users in 1 row. When there is One direction filtering from User to Bridge table, the measure for concatenatex is not filtered per row, it gives all user. When there is the both direction filtering, the measure works.
What do you recommend? Keep both direction or use Dax to solve it? How to enhance concatenate to be filtered? Some USERALATIONS?
Thank you
iwf you can use a function called CROSSFILTER to force the relationship to both.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
1 Reply
- parry2k
Super User
iwf you can use a function called CROSSFILTER to force the relationship to both.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!