Can not find column name

Power BI
1

in a table, there is a calculated column with if statement.
for exampleL
mycalccolumn = if (‘table1’[supplier]) = “xyz”, ‘table1’[address], ‘table1’[supplier] )

The above is fine and the column is calculated correctly in the table.
Now I would like to have a measure instead of this calculated column.
So then, as per my learnings from the enterprisedna videos, I create a key measures table by clicking in Home, enter data and then name the table ‘key measures’. In there I try to replicate the above measure but I see the message: can not find name supplier.
if I use sum (… then I can see the supplier column but I do not see the supplier column if I use IF
Any suggestions?
Thanks

2

What are you trying to do with the result of the if statement?

A measure will return an aggregated value based on the fuilters applied to the cell you are in, you cant use a measure as a field, you could use the result of the if statement in a measure to affect the calculation though.

Could you give more information about what you are trying to achieve, this will help all of us offer better advice, and im sure someone could then help resolve your problem.

1 Like