DAX formula for count if?

[blownbyyou]

So I am new to powerpivot and the DAX functionality, for the most part I have been able to google my way out of trouble. But unfortunately on this one I am completely stuck and was hoping to get some help. I am trying to do a simple countif but for some reason my forumulas keep coming back wrong or with errors...

The file is a list of all items booked in my company by day, I am trying to simply count the amount of occurrences that one item # has been on the list. Below is a simple idea of what I am trying to do...

Product #	Count
D1125a	5
D1125a	5
D1125a	5
D1125a	5
D1125a	5
D1137	2
D1137	2
D1138	1

<colgroup><col><col></colgroup><tbody>
</tbody>

I tried to do the formula =CALCULATE(COUNTROWS('Source Data'),FILTER('Source Data','Source Data'[Product Number]=EARLIER('Source Data'[Product Number]))) but that came back as an error so I figured it was an issue with my earlier statement so I tried this...


=CALCULATE(COUNTROWS('Source Data'),FILTER('Source Data','Source Data'[Product Number]="d1125a")) and it came backe with value of 1 regardless of how many times that item # was listed...

What am I doing wrong?

Thanks for the help..

 

[citizenbh]

This works for me for new column:

=CALCULATE(COUNTROWS(Source_Data);FILTER(Source_Data;Source_Data[Product #]=EARLIER(Source_Data[Product #])))

Remark: ; = ,

 

[citizenbh]

Add new column number row (NoRows) and create Pivot Table like on the picture:

[/IMG]