Forum Discussion

murillocosta's avatar
murillocosta
Helper I
3 years ago

Fixed variable vs Dynamic

Hi,   Could someone help me with the below?   I have the measure "OUT_FORECAST_W01", which I am using a fixed variable _WEEK and using on the SUMX function below which is returning the expected r...
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please try something like below.

 

OUT_FORECAST_W01 =
VAR MIN_RANK =
    CALCULATE (
        MIN ( 'SUMMARIZE'[Week Rank] ),
        'SUMMARIZE'[Total Pallets Hired] = 0,
        ALLSELECTED ()
    )
VAR MAX_RANK =
    CALCULATE (
        MAX ( 'SUMMARIZE'[Week Rank] ),
        'SUMMARIZE'[Total Pallets Hired] = 0,
        ALLSELECTED ()
    )
VAR _WEEK =
    CALCULATE (
        MAX ( 'SUMMARIZE'[Week] ),
        FILTER ( ALL ( 'SUMMARIZE' ), 'SUMMARIZE'[Week Rank] = MIN_RANK )
    )
RETURN
    SUMX (
        ALLSELECTED ( 'SUMMARIZE'[Week] ),
        IF ( 'SUMMARIZE'[Week] = _WEEK, [Total Outbound Forecast] )
    )