cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## 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 related values of table 4

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

9 REPLIES 9
Solution Sage

@CasaMoreira

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

New Member

Thank you.

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

Solution Sage

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

New Member

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?

Solution Sage

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

New Member

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?

Solution Sage

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.

Solution Sage

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

New Member

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]"...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors