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)
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.