Forum Discussion
Workaround for IFERROR in DAX using DirectQuery
I'm currently migrating a PBI report from Import mode to DirectQuery. But apparently this mode doesn't have IFERROR. Is there another function/workaround for this issue? The column is defined as foll...
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.