Forum Discussion
Using DAX to Filter a Table for a Status Column
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
Anonymous , Try like
Status = Switch(true(),
isblank([Difference From Target]), Blank() ,
[Difference From Target] > 0, "Green"
, "Red")
3 Replies
Anonymous , Try like
Status = Switch(true(),
isblank([Difference From Target]), Blank() ,
[Difference From Target] > 0, "Green"
, "Red")please help me to make table with target amitchandak