Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dax formule

hello i need some help to make a table visual   i want to make a table that if i select a name in a another table that it filters to table to the items of the name if i dont select anything in the ...
DAX
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

You can use the following DAX measure to filter the table based on the selected name in the other table:

Filtered Table = 
IF(
    ISFILTERED('Table'[Name]),
    CALCULATE([EXPRESSION], FILTER('Table', 'Table'[Name] = SELECTEDVALUE('Table'[Name]))),
    BLANK()
)

This measure checks if the 'Name' column in the 'Table' is filtered. If it is, then it filters the 'Table' to show only the rows where the 'Name' column matches the selected value. If it is not filtered, then it returns a blank table.

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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