topic Re: DAX If Else - Else is Blank in DAX Commands and Tips

DAX If Else - Else is Blank

denden — Wed, 18 May 2022 08:41:16 GMT

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)

Re: DAX If Else - Else is Blank

Anonymous — Mon, 23 May 2022 03:01:13 GMT

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.