Forum Discussion

strikw's avatar
strikw
Helper I
8 years ago
Solved

Return values greater than zero by making a count

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 t...
  • MFelix's avatar
    MFelix
    8 years ago

    Hi strikw,

     

    You need to have something like this:

     

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

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
8 years ago

Hi strikw,

 

You need to have something like this:

 

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

Regards,

MFelix

  • strikw's avatar
    strikw
    Helper I
    8 years ago

    Thank you very much,

    It worked perfectly.

    Have a great day.

    Att, Paulo Dantas.