topic Re: Removing filter context in DAX Commands and Tips

Removing filter context

murillocosta — Mon, 20 Mar 2023 07:13:02 GMT

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 the week I am filtering.

For example

https://easyupload.io/6dt7hk

Thanks

Re: Removing filter context

wdx223_Daniel — Mon, 20 Mar 2023 06:35:14 GMT

=CALCULATE([Total Outband Forcast],'SUMMARIZE'[Week]="2023-W10")

Re: Removing filter context

murillocosta — Mon, 20 Mar 2023 07:12:41 GMT

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

https://easyupload.io/6dt7hk

Cheers

Re: Removing filter context

wdx223_Daniel — Mon, 20 Mar 2023 07:56:27 GMT

OUT_FORECAST_W1 = SUMX(ALLSELECTED('SUMMARIZE'[Week]),IF('SUMMARIZE'[Week]="2023-W10",[Total Outbound Forecast]))

I'm worried about the operation efficiency.