Forum Discussion

Arxh3000's avatar
Arxh3000
New Member
3 years ago
Solved

Update Table data based on dropdown slicer selection

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

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.