How to display % change at Year level only if all quarters present

[Sax]

Hi community,

I got a simple model with a fact table, a dimension table and a calendar

I'm trying to find a way to display % change at year level only if all 4 quarters are in:

Looking at the example, is there a way to make -43.9% disappear until I got all 4 quarters for 2023?

These are my measures (3rd and 4th column):

2. Last Year Q/Y sales =
VAR LYSales =
    CALCULATE ( [1. Total Sales], PREVIOUSYEAR ( 'Calendar'[Dates] ) )
VAR LYQSales =
    CALCULATE ( [1. Total Sales], SAMEPERIODLASTYEAR ( 'Calendar'[Dates] ) )
RETURN
    IF (
        ISINSCOPE ( 'Calendar'[Quarter/Year] ) || ISINSCOPE ( 'Calendar'[Quarters] ),
        LYQSales,
        LYSales
    )

2.1 LY QoQ/YoY % =

DIVIDE(

    [1. Total Sales]-[2. Last Year Q/Y sales],

    [2. Last Year Q/Y sales]

)

Many thanks!

Sax

[amitchandak]

@Sax , use offset and use isinscope to switch measure- I have added that example in video

Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

[Sax]

@amitchandak Thanks for your reply. Unfortunately, it is not answering my question.
I do not have an issue with referring to previous quarter/Year sales.  
What I'd like is at year level to display % changes only when I got data for the full year, hence all four quarters should be in. Failing that, I'd like a blank.