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())
Sahir_Maharaj
Super User
Super UserHello 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())