Forum Discussion
Solved
Add a null condition in DAX
Hi all, I have to add a null condition in DAX. My condition is like: Measure = CALCULATE(sum(TAX_TRANSACTION[TAX_SUB_TRANS.AMOUNT]), FILTER(TAX_TRANSACTION,TAX_TRANSACTION[TAX_SUB_TRANS...
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
Null is BLANK() in DAX
https://msdn.microsoft.com/en-us/query-bi/dax/blank-function-dax
try this syntax
TAX_TRANSACTION[TAX_SUB_TRANS.REVERSE_FLAG] = BLANK()