ALL Function Not Working Well!

Hi Anonymous,

The problem could be that the measure you used the ALL function on is not being applied to the bar chart's visual level. When you interact with the bar chart by selecting a year, it could be filtering the visual level and therefore changing the calculation of your measure.

To solve this issue, you can try applying the same ALL function to the visual level of the bar chart as well. To do this, go to the "Visualizations" pane, click on the bar chart, and then go to the "Filters" section. Add your measure to the filters section and then click on the "Advanced controls" option. From there, select "Don't filter the measure" and then apply the ALL function to the visual level using the formula bar.

This should ensure that the measure is not affected by the bar chart's visual level and remains constant regardless of any interaction with the chart.

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and give Kudos to help the other members find it more quickly