Measure Y over Y some not working

[pcowman1]

I'm having a problem with the Year Over Year Quick Measure where it won't show the difference where zeros are involved. Has anyone else had this issue?

[aswin_k]

Hi @pcowman1,

Are you using Blank() function in your meaure? If so avoid that, so the measure returns Zero.
Regards
Aswin 

[pcowman1]

I'm using the standard Quick Measure:

Amount (LCY) YoY% =

IF(

    ISFILTERED('Customer Summary'[Posting Date]),

    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),

    VAR __PREV_YEAR =

        CALCULATE(

            SUM('Customer Summary'[Amount (LCY)]),

            DATEADD('Customer Summary'[Posting Date].[Date], -1, YEAR)

        )

    RETURN

        DIVIDE(SUM('Customer Summary'[Amount (LCY)]) - __PREV_YEAR, __PREV_YEAR)

)

[v-shex-msft · Accepted solution]

Hi @pcowman1 ,

I think this should be related to time intelligence function, it calculated based on the corresponding calendar. So if it does not contain specific date range records, Dax formula based on time intelligence functions also not calculate on these missed ranges.

I'd like to suggest you use date function to manually define the date range to calculate on a specific date range.

Time Intelligence "The Hard Way" (TITHW)  

BTW, you can also take a look at Dax auto-exist filter:

Understanding DAX Auto-Exist 

Regards,

Xiaoxin Sheng

[amitchandak]

Add 0 in your formula. In case you just want to remove blank

YOY% = {} + 0