Forum Discussion
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 CALCULATE function with filter but unfortunately I didnt succeed.
The name of the column is "Users".
Thanks for helping!
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.
4 Replies
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 , 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])
Anonymous - Try:
Measure = COUNTROWS(FILTER('Table',[Users]<>0)) Measure Distinct Count = COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER('Table',[Users]<>0),"Users",[Users])))
