Forum Discussion
Solved
Need Help with blanks/Error in table visual
I am converting an Excel report to Power BI. When I convert same formulas into DAX , some results are not similar to Excel. Excel returns #DIV/0! error but Power BI returns blanks, when ...
Hello Naveen_K_Gattu,
Can you please try this approach:
Formula A = DIVIDE(SELECTEDVALUE(Table[Column 2]), SELECTEDVALUE(Table[Column 1]))Formula B = DIVIDE(SELECTEDVALUE(Table[Column 4]), SELECTEDVALUE(Table[Column 3]))Formula D = IF(NOT(ISBLANK([Formula B])), ([Formula A] - [Formula B]) * SELECTEDVALUE(Table[Column 1]), BLANK())
I was using if (column = blank(),..) to solve it but it wasn't giving me the correct result, my measure had multiple conditions, so I used VAR and few ISBLANK conditions and got the expected results.
its strange that BLANK and ISBLANK dax returns different results.
Thank you for the response!