Forum Discussion
IF statement not recognizing table
I am writing an if statement in a measure that says essentially: IF( 'table'[this_date] > 'table'[that_date], 1, 0) but for some reason Power BI is not recognizing the table/columns. The table refere...
I am not an expert but when you are trying to create a refference to column inside a meassure you need to use a function like sum/average/distinc.
possible calculation could look like this but it wont give you exactly what you need. but just so you have an idea of how it would look like.
A=Calculate(if(sum('test vPassFailTestResults'[Last Failed])> sum( 'test vPassFailTestResults'[Last Passed]), 0, 1))
Otherwise why dont you create a column? Same function as you have there but instead of meassure create a column. Or is there a particular reason you need to have it as meassure?