Same measure showing 2 different values on same page

[ArchStanton]

Hi,

Can anyone explain why this measure all of the sudden is showing 2 different totals? The Card is showing a total of 1 but the exact same measure is 7,000+ (which is the correct total).
A customer just called me to point this out in the published report and I simply cannot explain it. Its been fine for 2 years, nothing has changed in the pbix file and this has never happened before.

I have copied the column chart and changed it to a Card and the figure is correct so why is this showing 1?

The measure is: 

YTD Closed Cases 3 = CALCULATE(
    TOTALYTD(COUNT('Cases'[Case Number]),
        'Cases'[Resolution Date],"31/03"),
            'Cases'[statecode] = "Resolved")

This published report automatically refreshes just after midnight each day.
This is so weird, is it a bug?

[Uzi2019]

Hi @ArchStanton 

Did you check the filter been applied to both the visual??

Might be visual level filter is being apply to card visual... please check 

If possible share the pbix so that we can have a look..

I hope I answered your question!

[ArchStanton · Accepted solution]

I think I've figured out what has happened, I have a second calendar 'Date' table that I need to fix.

Thanks for replying!