blownbyyou
New Member
- Joined
- Mar 29, 2017
- Messages
- 6
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...
<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..
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..