Forum Discussion
Simple bidirectional filtering between bar chart and matrix not working!
- 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:
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
This looks like exactly wha i need. Unfortunately I cam not able to rebuild your example. Could you share your .pbix example? That would be great.
- PaulDBrown1 year agoCommunity Champion
Sure, you can download it from here:
- UvonW1 year agoRegular Visitor
Thank you very much!!