Measure showing 2 different values on same page

[Pigbag1962]

Hi

I have a situation where a measure Com % Change is showing correctly in smart Narrative, but incorrectly in a bar chart.

The measure is 

COM % Change = divide([COM YTD]-[COM YTD LY],[COM YTD LY],0)

COM YTD = $2.10M, COM YTD LY = $1.97M, so result should be 6.82%. See screenshots.

Any thoughts greatly appreciated.

[VahidDM · Accepted solution]

Hi @Pigbag1962 

It works well on my sytem:

Have you used any other columns/Measures in that bar chart? did you apply a filter on visual/page/report [Or even selected a value on any slicers]?

Can you share the sample of your file or your data here to be able to work on it?

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

Appreciate your Kudos  !!

[Pigbag1962 · Accepted solution]

Thanks VahidDM.

I think the issue arose through copying the chart and then amending the value field to the measure. Having recreated the chart from scratch this issue has been removed.

Thank you for your early response though  and offer for additional help.

Damon

[VahidDM · Accepted solution]

Hi @Pigbag1962 

It works well on my sytem:

Have you used any other columns/Measures in that bar chart? did you apply a filter on visual/page/report [Or even selected a value on any slicers]?

Can you share the sample of your file or your data here to be able to work on it?

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

Appreciate your Kudos  !!