Forum Discussion

UvonW's avatar
UvonW
Regular Visitor
1 year ago
Solved

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...
  • PaulDBrown's avatar
    PaulDBrown
    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