How to surpass single filter direction?

Question

Hello everyoneI have the below datamodel:I have a table visualization with the content of table 4, and a slicer with the content of tableSelecting a value of table1, I want to see the related values of table 4This is not working because of the relationship direction from table 2 and table 3.Using a bi-directional filter is not an option (ambiguity).How can I accomplish this?

tharunkumarrtk · Answer

CasaMoreira&nbsp;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 upIf it solves your issue, please accept it as the solution to help the other members find it more quickly.Tharun

casamoreira · Answer

Thank you.can you give me an example? Where should I create the measure with the CROSSFILTER?

tharunkumarrtk · Answer

CasaMoreira&nbsp;&nbsp;Assuming your related table1_2 and table 2 with value2id columns&nbsp;CALCULATE (
            MAX(table4[value2id]),
            CROSSFILTER ( table1_2[value2id], table2[value2id], BOTH )
        )&nbsp;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 upIf it solves your issue, please accept it as the solution to help the other members find it more quickly.Tharun&nbsp;

casamoreira · Answer

I undestand....But I have filters (table 2 and 3) that are set in table 1And 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 · Answer

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 upIf it solves your issue, please accept it as the solution to help the other members find it more quickly.Tharun&nbsp;

Forum Discussion

How to surpass single filter direction?

9 Replies

Related content

Refresh error - Single Sign-on (SSO)-enabled Direct Query data source.

Matrix filter not working when using a single direction relationship

Single select slicer

Direct Lake

how to create single totals