PRODUCTX working for Line Chart, but not for Bar Chart

[JvH]

Hi,

I've got a measure defined to calculate the product of a column.

Total Return_pct =
CALCULATE(
    PRODUCTX(daily,daily[return_pct]) -1,
    FILTER(
        ALLSELECTED(daily),
        daily[date] <= MAX(daily[date])
    )
)

It nicely shows the return % over time, when displayed in a line chart:

When I use it in a bar chart, to show the return % for a certain period, it doesn't work (i.e. shows a value that seems consistent for all funds/categories:

Any thoughts on why and how to fix?

[daXtreme]

The first visual has time on the x-axis, so at each time point this is different: 

MAX(daily[date])

and hence the values on the chart are different.

I think the other visual does display the correct values, though. They are not the same. The last 3 are 100%, so there is some change. Nothing more can be said without seeing the dataset, I'm afraid.