Update Table data based on dropdown slicer selection

[Arxh3000]

Hello if just got a problem with Dropdown slicer updating it

When the journal "CC011003634662020" is Selected the Transactions_Lowest_Values_Average column values should be updated with their results (i dont just put those values in because i eventually want to have multiple journals in the dropdown menu which will replace Transactions_Lowest_Values_Average with their unique results 

my table should look like this when "CC011003634662020" is selected the selected journal is already removed from the results table 

heres a link to my workspace can't seem to figure out why i cant update the data 

any help would be appreciated thanks

https://ufile.io/wv8ghthe

[Anonymous · Accepted solution]

Hi @Arxh3000 ,

Please create a measure with below dax formula and add it to table visual filter and set:

Measure =
VAR _a =
    SELECTEDVALUE ( 'Table 2'[Product] )
VAR _b =
    SELECTEDVALUE ( 'Table'[Product] )
VAR _result =
    IF ( _a = _b, 0, 1 )
RETURN
    _result

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.