Forum Discussion

Umadhandapani's avatar
Umadhandapani
Helper II
4 years ago
Solved

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...
Need Help
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago

    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

NickolajJessen's avatar
NickolajJessen
Solution Sage
4 years ago

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

  • Umadhandapani's avatar
    Umadhandapani
    Helper II
    4 years ago

    Thanks a lot.

    • NickolajJessen's avatar
      NickolajJessen
      Solution Sage
      4 years ago

      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