Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Umadhandapani
Helper II
Helper II

Drillthrough with two different tables with same fields.

Hi,
This is my sample matric table .
Umadhandapani_0-1655449181727.png
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.

Umadhandapani_1-1655449410894.png

 

Umadhandapani_2-1655449425375.png


But I'm getting only the first format.

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


 

 

1 ACCEPTED SOLUTION
NickolajJessen
Solution Sage
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:

NickolajJessen_0-1655453662140.png

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

View solution in original post

5 REPLIES 5
NickolajJessen
Solution Sage
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:

NickolajJessen_0-1655453662140.png

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

Thanks a lot.

The only thing i added was this measure:

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
Appreciate your kudos

NickolajJessen
Solution Sage
Solution Sage

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.