ALL Function Not Working Well!

[Anonymous]

I have a measure called total orders and i used ALL function to keep this measure not change with order dates filter and it is worked...

But my problem is that i have a bar chart in x line is order date and y line is another measure about counting people who ordered..

when i press any year of the chart the measure number that i want to keep it not changing is changing here with this bar chart!

What is the problem !! 

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.

[ichavarria]

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