cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper II

## Drillthrough with two different tables with same fields.

Hi,
This is my sample matric table .

For example, let us take 'Org3' row, on clicking the value of Org3 (row) & Org1(column) value '20',
It leads to drill through page where it shoul show in two different table the data as,
Row*Column in one table Org3* Org1 = 20,
Another table Org1*Org3 = 10.

But I'm getting only the first format.

And, using card visual to show difference between two values.

1 ACCEPTED SOLUTION
Solution Sage

Well, the filter you  are passing is: Column1 MUST be org3 and Column2 MUST be org1. Therefore you will get that result in both tables. I see you tried switch the rows and column in the matrix. That's not how it works.

You can do like this though:

Notice how i'm switching the cols to get the "opposite" result on the matrix

5 REPLIES 5
Solution Sage

Well, the filter you  are passing is: Column1 MUST be org3 and Column2 MUST be org1. Therefore you will get that result in both tables. I see you tried switch the rows and column in the matrix. That's not how it works.

You can do like this though:

Notice how i'm switching the cols to get the "opposite" result on the matrix

Helper II

Thanks a lot.

Solution Sage

``````Selected Col 1 =
Var Col1 = SELECTEDVALUE('Table'[Column1])
Var Col2 = SELECTEDVALUE('Table'[Column2])

Return
CALCULATE(
[Measure 9],
FILTER(ALL('Table'), 'Table'[Column2] = Col1 && 'Table'[Column1] = Col2)
)``````

It might work with some adjustments.

If this post solves your problem, accept it as a solution

Solution Sage

This sounds real specific. Do you have a .pbix file to share?

Helper II

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors