Forum Discussion

murillocosta's avatar
murillocosta
Icon for Helper I rankHelper 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 t...
  • 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.
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

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

  • murillocosta's avatar
    murillocosta
    Icon for Helper I rankHelper 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
      Icon for Community Champion rankCommunity 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.