Return values greater than zero by making a count

[strikw]

Hello,

I'm having trouble returning the data in one measure, I want the measure to return me the data in a column that is greater than 0.

Ex: Table 1, cololuna1:
2
1
0
2
1
0


I want to count values that are greater than 0, that in this example the result is 4. And it has to be in a measure.

Thank you.

[MFelix · Accepted solution]

Hi @strikw,

You need to have something like this:

Count = Calculate ( Count (Table [Colum]), Table [Colum] > 0)

Regards,

MFelix

[strikw]

Thank you very much,

It worked perfectly.

Have a great day.

Att, Paulo Dantas.

[strikw]

Hello,

I'm having trouble returning the data in one measure, I want the measure to return me the data in a column that is greater than 0.

Ex: Table 1, cololuna1:
2
1
0
2
1
0


I want to count values that are greater than 0, that in this example the result is 4. And it has to be in a measure.

Thank you.

[jthomson]

Does CALCULATE(COUNTROWS(yourtable), yourcolumn>0) return the result you want?