Forum Discussion
Solved
Removing filter context
Hi Would someone able to help me with the below? - I have two measures out_forecast_w1 & out_forecast_w2 I need to replicate the result for all week intestead only for t...
- OUT_FORECAST_W1 = SUMX(ALLSELECTED('SUMMARIZE'[Week]),IF('SUMMARIZE'[Week]="2023-W10",[Total Outbound Forecast]))I'm worried about the operation efficiency.
Tks Daniel;
Ive tried with calculate but as my [Total Outbound Forecast] measure is quite complex calculation isn't returning anything using calculate. Do you know any trick that would work?
Follow the file below
Cheers
OUT_FORECAST_W1 = SUMX(ALLSELECTED('SUMMARIZE'[Week]),IF('SUMMARIZE'[Week]="2023-W10",[Total Outbound Forecast]))
I'm worried about the operation efficiency.