Forum Discussion
vilenm
Helper II
5 years agoDax performance using isblank
Hi
I noticed using Example 1 = IF(([A]-[B]) =BLANK(),0,[A]-[B]) or IF(ISBLANK([A]-[B]),0,[A]-[B]) can cause performance issues especially when building from a tabular model. Any efficient way to replace BLANKS with 0s?
thanks
vilenm , Try like
[A]-[B] +0
1 Reply
- amitchandak
Super User
vilenm , Try like
[A]-[B] +0