Forum Discussion
How to surpass single filter direction?
Super UserIn power bi measures are bind to any table, you can create measures in any table. I hope this answers your question.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
The problem is that creating this measure will not return a single value, but a list of connected values... So creating this measure in Table 2 will not work. Doesn't it make sense?
- tharunkumarRTK
I corrected the measure and added aggregation, please copy it again and test it.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Creating the measure below in table 2 doesn't work because of the "MAX" -> only returns one item...
Should we create it in other table?- tharunkumarRTK
Yes this measure will only retrieve one scalar value. If you want to retrieve all values and consider modifying your model and follow star schema parctices then you would not require crossfilter function.