Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Missing count when comparing two columns in same table

Missing count= VAR __data = CALCULATE( DISTINCTCOUNT( table1[column1]), ISBLANK(table1[column2])) RETURN IF(__data>0, __data,"")  this query returning me blank though column2 containing blank...
Need Help
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi  Anonymous

try like:

Missing count=
VAR __data =
COUNTROWS(
    FILTER(
        table1,
        table1[column2]=BLANK()
    )
)
RETURN
IF( __data>0, __data,"")