Forum Discussion

murillocosta's avatar
murillocosta
Helper I
3 years ago
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 the week I am filtering.

 

 

For example 

 

 

https://easyupload.io/6dt7hk

Thanks

 

  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago
    OUT_FORECAST_W1 = SUMX(ALLSELECTED('SUMMARIZE'[Week]),IF('SUMMARIZE'[Week]="2023-W10",[Total Outbound Forecast]))
    I'm worried about the operation efficiency.

3 Replies

    • murillocosta's avatar
      murillocosta
      Helper I
      3 years ago

      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

      • wdx223_Daniel's avatar
        wdx223_Daniel
        Community Champion
        3 years ago
        OUT_FORECAST_W1 = SUMX(ALLSELECTED('SUMMARIZE'[Week]),IF('SUMMARIZE'[Week]="2023-W10",[Total Outbound Forecast]))
        I'm worried about the operation efficiency.