I'm trying to accomplish the same as with a normal COUNTIF function in Excel but in PowerPivot. The function is =COUNTIF(A:A,A1).
The result should look like this:
<colgroup><col><col></colgroup><tbody>
</tbody>
The result should look like this:
Items | Count_Distinct_Item |
B180030.989.L | 2 |
B180030.989.M | 1 |
B180030.989.XL | 2 |
B180030.001.L | 1 |
B180030.001.M | 2 |
B180030.001.S | 1 |
B180030.001.M | 2 |
B180030.989.L | 2 |
B180030.989.XL | 2 |
B180030.989.XXL | 1 |
<colgroup><col><col></colgroup><tbody>
</tbody>