Forum Discussion

vilenm's avatar
vilenm
Icon for Helper II rankHelper II
5 years ago
Solved

Dax 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