Forum Discussion

strikw's avatar
strikw
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper I rankHelper I
8 years ago

Thank you very much,

It worked perfectly.

Have a great day.

Att, Paulo Dantas.