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 ...
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.

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.