Create count measure

[Anonymous]

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 CALCULATE function with filter but unfortunately I didnt succeed.

The name of the column is "Users".

Thanks for helping! 

[Greg_Deckler]

@Anonymous - Try:

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

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

[Anonymous · Accepted solution]

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.

[Anonymous]

Yeah that's what I meant,

Thanks!

[amitchandak]

@Anonymous , Try like

count of user = countx(summarize(Table,Table[user], "_1", [Measure]+0),[user])
count of user = countx(values(Table[user]),[Measure]+0)

Just for ref

count of user >0 value= countx(filter(summarize(Table,Table[user], "_1", [Measure]),[_1]>0),[user])