Fixed variable vs Dynamic

[murillocosta]

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 result

So, the result of this measure is to repeat the [Total Outbound Forecast] value on this columns and that's exactly what I need.

My problem is that when I am trying to build the same measure in a more dynamic way getting the MAX and MIN rank and filtering the week variable I'm not having the expected result.....It seems that a filter context is being applied.

For example

Thanks

File: 

https://easyupload.io/abu3zu

[Jihwan_Kim]

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] )
    )