topic Re: Measure value does not change dynamically in an error bar when selecting value from a visual in DAX Commands and Tips

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

Oodi — Sun, 09 Jun 2024 07:53:37 GMT

Hello,

I'm trying to make a measure value change dynamically in an error bar (low point) by selecting a value from a visual like table or matrix.

For some reason when selecting a value from any visual other visuals are filtered by it but the error bar (low point) value is not filtered. However when selecting a value from a slicer also the error bar value filters.

Value selected from a slicer:

Value selected from a visual.

Currently the measure value only reacts to slicer selection but when selecting value from a visual the error bar value remains unfiltered.

Measure in the error bar is a basic SUM() in a CALCULATE()

Any ideas?

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

xifeng_L — Sun, 09 Jun 2024 16:35:56 GMT

Hi Oodi

Assuming the expression is correct, it is possible that the interaction between visual objects is blocked, you can check if the option is checked as shown below.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

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

Oodi — Mon, 10 Jun 2024 07:12:37 GMT

Thanks for the idea,
checked and the option was disabled.

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

Anonymous — Mon, 10 Jun 2024 10:45:40 GMT

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.