Fixed variable vs Dynamic

murillocosta — Tue, 21 Mar 2023 03:15:19 GMT

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

Re: Fixed variable vs Dynamic

Jihwan_Kim — Tue, 21 Mar 2023 03:31:03 GMT

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

topic Re: Fixed variable vs Dynamic in DAX Commands and Tips

Fixed variable vs Dynamic

Re: Fixed variable vs Dynamic