Zero Index Calculation suddenly stopped working

[rjg2g11]

Hello, 

I have logged into Power Bi this morning, both Service and Desktop, and one of my calculations have broken. I havent refreshed the data nor changed anything. Please see below a before and after, and also my DAX measure.

Index Reportable Owner = 
VAR w1 =
   SELECTEDVALUE(EPOS[Week End Date])
VAR w2 = 
    MIN(Dates[Week End Date])
RETURN
    IF (
        w1 >= w2,
        [Share - Reportable Owner]
            - CALCULATE ( [Share - Reportable Owner], EPOS[Week End Date] = w2),
        BLANK ()
    )

Can anyone advise?

[v-yuezhe-msft · Accepted solution]

@rjg2g11,

What is your data source? Have you checked that if the data source is changed? And could you please verify that if the data in your table matches the output of the second chart?

Regards,
Lydia

[rjg2g11]

@v-yuezhe-msft

Hi, 

This has now been resolved - there was a change in our data warehouse that impacted my charts!

Thanks for you input

Rob