Forum Discussion
How to surpass single filter direction?
Super UserCasaMoreira
You can use CROSSFILTER dax function and tweak the directionality for that one particular calculation to 'BOTH' instead of SINGLE.
https://dax.guide/crossfilter/
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
Thank you.
can you give me an example? Where should I create the measure with the CROSSFILTER?
- tharunkumarRTK
Assuming your related table1_2 and table 2 with value2id columns
CALCULATE ( MAX(table4[value2id]), CROSSFILTER ( table1_2[value2id], table2[value2id], BOTH ) )
Your model is deviating from the principles of star schema, and it is not a good practice 🙂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
I undestand....
But I have filters (table 2 and 3) that are set in table 1
And these filters are available in table 4... So I couldn't find any other way to do this...
For the expression shared:CALCULATE ( table4[value2id], CROSSFILTER ( table1_2[value2id], table2[value2id], BOTH ) )I tried to add this as a measure in Table 2, but it's not allowing the first paramenter of the CALCULATE function "table4[value2id]"...
Can you please help here? 😞
- tharunkumarRTK
In 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