Forum Discussion

EdK99's avatar
EdK99
Frequent Visitor
3 years ago
Solved

COUNT, COUNTROWS, and COUNTA are returning wrong values

Hello,   I'm trying to use the count functions and they are returning different values than what they're supposed to.   Measure LIVE Orders = CALCULATE(COUNTROWS(Table2022), 'Table2022'[Order St...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    Blank equates to 0 so don't use var = BLANK(), or var <> BLANK(). Instead use the ISBLANK() function, or NOT ISBLANK()

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Blank equates to 0 so don't use var = BLANK(), or var <> BLANK(). Instead use the ISBLANK() function, or NOT ISBLANK()

EdK99's avatar
EdK99
Frequent Visitor
3 years ago

That did it!! thanks a lot