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())
Can tou try this :
Formula B =
IF(
ISBLANK([Column 3]) || [Column 3] = 0,
BLANK(),
[Column D] / [Column 3]
)
Formula D =
IF(
ISBLANK([Formula B]),
BLANK(),
([Column E] - [Formula B]) * [Column A]
)
If this post helps, then please give Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.