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)
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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!