Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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
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
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
This sounds real specific. Do you have a .pbix file to share?
Herewith I have shared the link.
https://www.dropbox.com/s/rgug4xqk3iruamq/SampleTest.pbix?dl=0
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |