How to count distinct values in a column?

[Anonymous]

Hello,

How can I count only the "1" in al column.

The column has 3 different values:  1, [Empty] and -1.

I need it to make a measure: percentage of the "1" of the total  (1 and -1).  

Thanks,

Mark

[Chihiro · Accepted solution]

There are several ways.

I'd probably use...

=COUNTROWS(FILTER(Table, [Column]=1))

[AkhilAshok]

Do you mean this:

PercentageOfOne =
VAR CountOfOne =
    CALCULATE ( COUNTROWS ( Table ), Table[Column] = 1 )
VAR CountOfRest =
    CALCULATE ( COUNTROWS ( Table ), NOT ( ISBLANK ( Table[Column] ) ) )
RETURN
    DIVIDE ( CountOfOne, CountOfRest )

[affan · Accepted solution]

Hi @Anonymous,

You can use the following measure for count

Count1 = CALCULATE(COUNT(Table1[Column1]),FILTER(Table1,Table1[Column1]=1))

For calculating the percent you can use the following measure 

Percent = var rowsc=COUNTROWS(Table1)
return 
CALCULATE([Count1]/rowsc)*100

You can view the pbix file here

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

Regards,

Affan

[Chihiro · Accepted solution]

There are several ways.

I'd probably use...

=COUNTROWS(FILTER(Table, [Column]=1))