Count Item of a Table

[samihuq]

Hi,

I have a table names "Payment" as follows with four filed. 

I need to generate the fourth coulumn CountItem.

In excel it was farely simple using the countif(), how do we do it here using dax?

Item Date Amount CountItem

A 01-Jan-2018 10  3

A 02-Jan-2018 10 3

A 03-Jan-2018 10 3

B 01-Jan-2018 10 2

B 02-Jan-2018 10 2

C 01-Jan-2018 10 2

C 02-Jan-2018 10 2

Thanks,
Sami

[Zubair_Muhammad · Accepted solution]

HI Sami @samihuq

CountItem =
VAR myitem = TableName[Item]
RETURN
    COUNTROWS ( FILTER ( TableName, TableName[Item] = myitem ) )

[v-yuezhe-msft · Accepted solution]

@samihuq,

You can also use the following DAX.

CountItem = CALCULATE(COUNT(Table[Item]),ALLEXCEPT(Table,Table[Item]))

Regards,

Lydia

[samihuq]

Thanks @v-yuezhe-msft your solution also worked like a charm 🙂

[Zubair_Muhammad · Accepted solution]

HI Sami @samihuq

CountItem =
VAR myitem = TableName[Item]
RETURN
    COUNTROWS ( FILTER ( TableName, TableName[Item] = myitem ) )

[samihuq]

Thanks @Zubair_Muhammad that worked like a charm 🙂