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 values. can anybody help me out

 

Need Help

2 Replies

  • 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,"")