filtering measure results without affecting measure

[Anonymous]

I've created a report that forcasts and adds in seasonality to the linear regression. Then it multiplies that to come up with a "What If"

The problem is I only want to show values where the fiscal week of the calculation is after the current fiscal week. However, when I try to filter this at the visual level or within the DAX it removes all the values. It's because I need the all the data points up to the current fiscal week to calcualte the linear rgression and removing them blanks out my forcast calc.  So, What I want is the above table but to only show the rows after our current fiscal week without actually filtering out any of the data. Perferably in DAX so I can show the same chart but the "What If" line will only appear after the end of the "CY Units" line. 

Any help on this would be appreciated. 

[Anonymous · Accepted solution]

The What if line does use the built in parameters option. But I did figure this out. I duplicated by calendar table then built my measure filtering on that to show BLANK() when the week is less than the current week. This kept the values the same but doesn't show the unwanted values. 

[lbendlin]

I would recommend you use the built-in What-If features in Power BI rather than rolling your own.

Please provide sample data in usable format (not as a picture - maybe insert into a table?) .