Forum Discussion

CasaMoreira's avatar
CasaMoreira
New Member
2 years ago

How to surpass single filter direction?

Hello everyone I have the below datamodel: I have a table visualization with the content of table 4, and a slicer with the content of table Selecting a value of table1, I want to see the r...
Need Help
tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

CasaMoreira 

 

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

 

CasaMoreira's avatar
CasaMoreira
New Member
2 years ago

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? 😞