Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to filter the table by chart visual?

Hey there! So what we have here are: 1) "Status" chart 2) "Readiness" column in the table Both status chart sections and flag icons in the column are measures. A specific table is cre...
chart
DAX
Filtering
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Don't you have a common linked column between these two tables? Like some product serial number, or id number or something like that? Maybe you can bridge the two tables that are not related by using a third table that is related.
    Because I think you can't do effective filtering if there is no association between the two tables.

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    That was a good idea, unfortunately, it didn't work:( 

    Let me share more so it might help:
    - The legend of the donut chart comes from the calculated table:

    - Values for the donut chart come from the measure:

    Flag Count = 
VAR CurrentFlag =
    SELECTEDVALUE ( 'Status Chart Filter Table'[Flag] )
VAR T1 =
    ADDCOLUMNS (
        VALUES ( 'All Project v2'[Project Name] ),
        "@Flag", [FRU stat chart] #this measure is a set of conditions, which assigned a 
                                  #corresponding flag to the value in the column 
                                  #that should get filtered
    )
VAR T2 =
    FILTER ( T1, [@Flag] = CurrentFlag )
RETURN
    COUNTROWS ( T2 )

    I know there are no relationships between the donut chart table and everything else, but if they play a crucial role here, how would I establish them?