Make table blank until filtered by another table

[rogerdea]

Hi - i have been looking at similar posts where tables are set to be blank until a slicer value has been selected, but I have not found any yet which does a similar thing, but from a table row being selected.

This shows what i have currently (CURRENT), and the effect i am trying to achieve.  The two data tables are joined on [ID].

What DAX could i use to achieve this?  I tried playing around with IF(CROSSFILTER but not sure this works when selecting a row in a table?  Is this possible?

The above image is an example, my real file has too much confidential information to post.

Thanks

[Anonymous]

Hi @rogerdea ,

Please check this blog, it should suit your needs.

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/ 

Best Regards,

Jay

[amitchandak]

Actually you check is filtered for any of the filter

example

if(isfiltered(Param1[Param1])  || isfiltered(Param2[Param2]) , [measure], blank()) //add more as per need 

refer : https://www.youtube.com/watch?v=hXg3kRFSGjA