Forum Discussion
Add a null condition in DAX
Null is BLANK() in DAX
https://msdn.microsoft.com/en-us/query-bi/dax/blank-function-dax
try this syntaxTAX_TRANSACTION[TAX_SUB_TRANS.REVERSE_FLAG] = BLANK()
Hi zlokesh
I think you're incorrect - ISBLANK is checking whther a given expression is BLANK or not, returning TRUE/FALSEhttps://msdn.microsoft.com/en-us/query-bi/dax/isblank-function-dax
BLANK() will return a blank/null value
https://msdn.microsoft.com/en-us/query-bi/dax/blank-function-dax
Hello Lokesh,
I have to add simple condition not the if condition like
Sum of sale where regime_code = N or Null
Is there any way to add this condition in DAX.
I am facing problem in Null .If condition will not resovle my issue.
Thanks,
Narender
Dear Narender,
ISBLANK is the function for NULL. use ISBLANK to check NULL.
Your expression will be like below, Please check in editor for accuracy.
Measure =
CALCULATE(ISBLANK(sum(TAX_TRANSACTION[TAX_SUB_TRANS.AMOUNT]),
FILTER(TAX_TRANSACTION,TAX_TRANSACTION[TAX_SUB_TRANS.REVERSE_FLAG]="N" )&& (TAX_TRANSACTION[TAX_SUB_TRANS.CHARGE_TYPE_NO]=2 ||TAX_TRANSACTION[TAX_SUB_TRANS.CHARGE_TYPE_NO]=13 ||TAX_TRANSACTION[TAX_SUB_TRANS.CHARGE_TYPE_NO]=15)))
Thanks
Hi zlokesh
I think you're incorrect - ISBLANK is checking whther a given expression is BLANK or not, returning TRUE/FALSEhttps://msdn.microsoft.com/en-us/query-bi/dax/isblank-function-dax
BLANK() will return a blank/null value
https://msdn.microsoft.com/en-us/query-bi/dax/blank-function-daxHi Stachu,
Blank() is working in Dax.
Like
Reverse_Flag= N || Reverse_Flag=Blank().
It's not quite correct though because if they use the blank in a calculation it will count as 0 not NULL. Which will introduce errors.
As in this article https://www.sqlbi.com/articles/how-to-handle-blank-in-dax-measures/