Using DAX to Filter a Table for a Status Column

[mccardj]

Hi all,

I've trying to create a Status column based on whether the 'Difference From Target' column is positive or negative using this DAX as a measure:

Status = IF([Difference From Target] > 0, "Green", "Red")

However, when I do so the table changes to below to include ALL phases instead of filtering based on the selected table.

How do I update the DAX to make the selected table (1st table) keep its current values?

Thanks all

[amitchandak · Accepted solution]

@mccardj , Try like

Status = Switch(true(),
isblank([Difference From Target]), Blank() ,
[Difference From Target] > 0, "Green"
, "Red")

[mccardj]

Worked perfectly! Thanks so much! Subscribed to your channel 🙂