Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
murillocosta
Helper I
Helper I

Removing filter context

Hi

 

Would someone able to help me with the below?

 

- I have two measures out_forecast_w1 & out_forecast_w2

 

murillocosta_2-1679293741752.png

 

murillocosta_3-1679293760572.png

 

I need to replicate the result for all week intestead only for the week I am filtering.

 

murillocosta_1-1679293663883.png

 

For example 

 

murillocosta_4-1679293889480.png

 

https://easyupload.io/6dt7hk

Thanks

 

1 ACCEPTED SOLUTION

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

View solution in original post

3 REPLIES 3
wdx223_Daniel
Super User
Super User

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

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

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors