DAX If Else - Else is Blank

[denden]

I want to create a measure with if else. The logic step is to check if a month is older than March, if that is the case the column uniquePageViews should be selected else the colum total engagers, but if I check March the field is always blank and I don't know why.

TotalEngager or UniquePageviews =
VAR month= SUM('X'[Date (month)])
VAR uniquePageviews = SUM('X'[UniquePageViews])
VAR TotalEngagers = 'Measure Table'[Total Engagers]
RETURN IF.EAGER(month > 202203, uniquePageviews, TotalEngagers)

[Anonymous]

Hi @denden 

Your TotalEngager is a measure, right ? Can you provide your sample with detailed data ? Or you can also provide full pbix file (remove sensitive data) .  Based on the formula you're currently providing, I have no way of telling why you're returning blank.

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.