Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create count measure

Hey,   I'm trying to create a measure that will count all the numbers at the column, but only those who greater then 0 (the measure will NOT count null cells and 0 number).   I tried the CALCULAT...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello, Im not sure if you'd expect an outcome of 91, or 20 with the shown data; so i made both measures. 

    If you'd expect to see 91 (thats the total of the values) you can use:

    Measure = SUM(TableUsers[Users])

    If you'd expect to see 20 (the count of rows where there is no NULL or 0 you can use:
     

    Measure 2 = CALCULATE(COUNT(TableUsers[Users]),TableUsers[Users] > 0)

     

    Goodluck,

     

    Eric.

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

Anonymous - Try:

Measure = COUNTROWS(FILTER('Table',[Users]<>0))

Measure Distinct Count = COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER('Table',[Users]<>0),"Users",[Users])))