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

1 Reply

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