DAX measure: if statement to return a variable as blank based on condition

Question

I have a table like this:

My "Delta" column is a measure I created, looking like this:

 Delta = 
VAR delta = (DIVIDE(
    SUM('Devices Data'[count]),
    'Devices Data'[Count LY])
    -1)

RETURN IF(ISBLANK(SUM('Devices Data'[count])), BLANK(), FORMAT(delta,"Percent"))

I would actually like to set my "delta" variable as BLANK() when "Count LY" is empty. However, my formula doesn't seem to render it properly, even when I'm trying this in the if statement:

BLANK(delta)

Is there a way to display my delta column as empty (blank) when Count LY is empty?

Thank you in advance for your help

Leyth · Accepted Answer · 2025-06-03 20:35:59Z

2

You will need to modify your DAX measure, more precisely in the IF statement you will need to test on Count LY column and not on count column. Try the following measure:

Delta = 
VAR delta = (DIVIDE(
    SUM('Devices Data'[count]),
    'Devices Data'[Count LY])
    -1)

RETURN IF(ISBLANK('Devices Data'[count LY]), BLANK(), FORMAT(delta,"Percent"))

answered Jun 3 at 20:35

Leyth

7011 gold badge5 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Para Jun 4 at 6:31

I feel so dumb, you're entirely correct. Thank you for noticing me, I don't know how I could miss this.

Collectives™ on Stack Overflow

DAX measure: if statement to return a variable as blank based on condition

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related