Forum Discussion
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
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 _resultPlease 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
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 _resultPlease 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.