Forum Discussion
UvonW
1 year agoRegular Visitor
Simple bidirectional filtering between bar chart and matrix not working!
Hello, for me it assumes like a very simple problem, but I do not know, why it is not working. I want to create a bar chart and a matrix that can be filtered interactively in both directions. I...
- 1 year ago
Ok see if this works for you. Duplicate the single table and set up th emodel as follows.
Duplicate this table
Now create two measure to act as filters for each corresponding table:
Filter Person T1 = COUNTROWS ( CALCULATETABLE ( VALUES ( 'Dim ID'[dID] ), FILTER ( 'Table 2', SUM ( 'Table 2'[Wert] ) <> 0 ) ) )Filter Person T2 = COUNTROWS ( CALCULATETABLE ( VALUES ( 'Dim ID'[dID] ), FILTER ( 'Table 1', SUM ( 'Table 1'[Wert] ) <> 0 ) ) )Add the ID column from the ID dimenion table and set up each filter with its corresponding measure in the filter pane
and this is the final result
- 1 year ago
Sure, you can download it from here:
UvonW
1 year agoRegular Visitor
Yes I checked that:
2Attribut
and for 1Attribut
Unfortunately it is in German