Excel Calculation in Power bi

[DazzaRCIB]

Morning,

I'm trying to recreate a calulation from excel into Power bi but with no luck so far:

On a calulated column I want to count how many times a number occurs? Any help would be great.

[Chakravarthy · Accepted solution]

Hi @DazzaRCIB 

Please try giving the below code

COUNTIF =

COUNTROWS(

    FILTER(Table,Table[Column]=EARLIER(Table[Column]))

)

[Anonymous · Accepted solution]

Hi @Chakravarthy ,thanks for the quick reply, I'll add further.

Hi @DazzaRCIB ,

The Table data is shown below:

Use the following DAX expression to create a measure

Count = COUNTROWS('Table')

[Chakravarthy · Accepted solution]

Hi @DazzaRCIB 

Please try giving the below code

COUNTIF =

COUNTROWS(

    FILTER(Table,Table[Column]=EARLIER(Table[Column]))

)

[DazzaRCIB]

This would work as a column but I need it as a measure?