Forum Discussion
DAX for If with Filter
Hi,
I am little new to DAX so need help. I want to right a DAX showing static values with an IF condition. What I am after is below.
NewColumn = If the value in the color column is "Red" then show 50 else show 100
what I wrote was
NewColumn = If( Filter (Table,ColumnName = "Red"),50,100)
However, it gave me an error saying "The expression referes to multiple columns. Multiple columns cannot be converted to a scalar value."
Please can some one help me with correct DAX for what I want to acheive here?
Thanks
Yash
6 Replies
- malagari
Continued Contributor
The FILTER function returns a table, and the IF doesn't know how to work against an entire table (the multiple columns error).
Are you essentially trying to do this?
Item | Color | NewColumn 1 Red 50 2 Red 50 3 Blue 100
If this is the case, you can simple do:
NewColumn = IF( [Color] = "Red", 50, 100 )
When you are creating a calculated column, it is calculating the value of the cell within a row context. This means that when it's calculating the value for NewColumn in Row 1 (from the example above), it knows about the [Item] and [Color] column.
- malagari
Anonymous Thanks for the info. I'll need to know a little more about your table structure. What table is the Color column in, where are you trying to add this 'NewColumn', and how do these tables relate together?
