How to set-up Drill-trough to the table that is not filter by another tabe

[yakovlol]

Hello community,

Could you please advise if there is a way to set up a drill-trough through the 2 tables? That has cross filter direction is single

I cannot to set cross filter direction to Both due to my RLS, but need that behaviour for drill troug page.

Maybe there is a way to activate this relanship in some measure?

Thank you!

[v-zhengdxu-msft · Accepted solution]

Hi @yakovlol 

Maybe you can create a new table with both two tables' data by using crossjoin() function.

Table =
FILTER (
    CROSSJOIN ( TABLE1, TABLE2 ),
    TABLE1[Company Name] = TABLE2[Company Name]
)

Here is the link for your reference.

CROSSJOIN function (DAX) - DAX | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Daoud_H]

Hi @yakovlol,

I think the method DAX "USERELATIONSHIP" could help you, it will temporary activate an inactive relation.

[yakovlol]

Table 1 and Table 2 - already have a relationship and it's active

I need something that will activate biderectional filtering of 2 tables