Forum Discussion
PSB
Helper III
Helper IIIDAX to count values based on condition
I need count column.
for same values in "Category" column, for example fruits but there are three different type of fruits in Product column, I need count as 3.
In vegetable, there are two raws with category "Vegetable" but in Product there is only one type of vegetable (Eggplant), I need count to be 1.
Product | Category | Count |
| Apple | Fruits | 3 |
| Apple | Fruits | 3 |
| Pinaple | Fruits | 3 |
| Banana | Fruits | 3 |
| Eggplant | Vegetable | 1 |
| Eggplant | Vegetable | 1 |
Try the following:
Count Column = CALCULATE(DISTINCTCOUNT(Product), ALLEXCEPT(Category))I get this error. could you please share exact formula?
Too many arguments were passed to the DISTINCTCOUNT function. The maximum argument count for the function is 1.
- Column = CALCULATE(DISTINCTCOUNT('Table'[Product]),ALLEXCEPT('Table','Table'[Category]))
