Forum Discussion
Workaround for IFERROR in DAX using DirectQuery
amitchandak I tried to convert it into a measure. Now the error is the following:
The column 'Table[x]' either doesn't exist or doesn't have a relationship to any table available in the current context.
The weird thing is that the column exists. Not only that but I also have a relationship between the current table and the main 'Table', with cardinality *:1, with cross filter direction on "Both" and the relationship is active.
Anonymous , Try like
value =
VAR z = MINX('Table2',
MAXX('Table2',
IFERROR(
RELATED('Table'[x]),
BLANK()),
0.1),
10000000)*[y]
RETURN IF(z>=2000,
ROUND(z,-2),
IF(z>1,
ROUND(z,0),
IF(z=0,
0,
1
)
)
)
amitchandak Tried it, but there's another error:
Too many arguments were passed to the MAXX function. The maximum argument count for the function is 2.
The thing is, I need to find the highest (and lowest with MIN function) between two expression, not only in a certain column.
I tried to remove the numbers on the MAXX and MINX, now both functions have 2 arguments. But the error is:
OLE DB or ODBC error: Exception from HRESULT: 0x80040E57