Future dates not recognising product category filter

[v-xuding-msft]

Hi @slim ,

I find that the old description is removed. Have you resolved your problem? If yes, please accept the helpful answer as a solution. And welcome to share your own solution. If you still have questions, please share some sample data and expected results. Then we will understand clearly and solve it quickly.

[nandukrishnavs]

@slim 

Try this

PIR Forecast =
VAR __Products = { "ABC", "PER", "XYZ" }
VAR __selectedProduct =
    SELECTEDVALUE ( Products[Product] )
VAR __forecast =
    CALCULATE (
        IF (
            SELECTEDVALUE ( Dates[Weeknumber] ) > 'Last Impact'[Last Sales week],
            .2,
            BLANK ()
        )
    )
//copied forecast logic from your snapshot
VAR __result =
    IF ( __selectedProduct IN __Products, __forecast, BLANK () )
RETURN
    __result

If this is not working, please share your pbix file or sample datasets in a tabular format. 

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂