Forum Discussion

VM_0451's avatar
VM_0451
New Member
5 years ago
Solved

Using Dax Measure to count all rows in a single column except for one specified value

Hi all,   I will keep this short in the first instance as I have had trouble signing in to the board (my last post got eaten). Essentially, I have a large dataset of weekly staff activity, collate...
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    VM_0451 Without sample data and expected output I can only guess but it sounds like:

    Measure = COUNTROWS(FILTER('Table',[Activity] <> "No Data Submitted"))

or

Measure = CALCULATE(COUNT('Table'[Name]),[Activity] <> "No Data Submitted")

    If this is not it, @ me in a reply and provide sample data and expected output. 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

VM_0451 Without sample data and expected output I can only guess but it sounds like:

Measure = COUNTROWS(FILTER('Table',[Activity] <> "No Data Submitted"))

or

Measure = CALCULATE(COUNT('Table'[Name]),[Activity] <> "No Data Submitted")

If this is not it, @ me in a reply and provide sample data and expected output. 

  • VM_0451's avatar
    VM_0451
    New Member
    5 years ago

    Yep, that did it.

    I got close with my previous attempts but messed up the syntax by not knowing about <>

     

    Thanks very much!