Combination Annualized/Static Data for One Bar Chart

Hi Anonymous 

Based on my understanding, your table has complete data for 2017-2019, but for 2020, there is only some weeks' data.

So you want to use average weeks' data for 2020 to predict whole year's data

by mutilpying average week's data by numbers of weeks of 2020.

To say easier, it is like below:

average weeks' data= total counts of 2020/weeks which data is not blank

numbers of year 2020=53

final=average weeks' data*53

If so,please look at my measure below:

modify count =
VAR n_weeks =
    CALCULATE (
        DISTINCTCOUNT ( 'Calendar'[WeekNumberOfYear] ),
        FILTER (
            ALLSELECTED ( 'Calendar' ),
            'Calendar'[Year]
                = YEAR (
                    TODAY ()
                )
        )
    )
VAR sum_count =
    CALCULATE (
        COUNT ( Turnover[Departments Names] ),
        FILTER (
            ALLSELECTED ( Turnover ),
            Turnover[Year]
                = YEAR (
                    TODAY ()
                )
        )
    )
VAR counts_weeks =
    CALCULATE (
        DISTINCTCOUNT ( Turnover[Week Number] ),
        FILTER (
            ALLSELECTED ( Turnover ),
            Turnover[Year]
                = YEAR (
                    TODAY ()
                )
        )
    )
RETURN
    IF (
        MAX ( 'Calendar'[Year] )
            = YEAR (
                TODAY ()
            ),
        n_weeks
            * DIVIDE (
                sum_count,
                counts_weeks
            ),
        CALCULATE (
            DISTINCTCOUNT ( Turnover[Departments Names] ),
            FILTER (
                ALLSELECTED ( Turnover ),
                Turnover[Year]
                    = MAX ( Turnover[Year] )
            )
        )
    )

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.