Measure value does not change dynamically in an error bar when selecting value from a visual

Hi Oodi ,

Based on my testing, please try the following methods:

1.Create the simple table.

2.Drag the Inventory table item field into the table visual.

3.Create the new measure to calculate the values based on the table visual selected.

Sum Transaction = 
CALCULATE(
    SUM('Inventory table'[Quantity]),
    FILTER(
        'Inventory table',
        'Inventory table'[Item No] = SELECTEDVALUE('Table'[Item No])
    )
)

4.Select the Item in the table visual and the result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.