DAX to count values based on condition

[PSB]

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

[vicky_ · Accepted solution]

Try the following:

Count Column = CALCULATE(DISTINCTCOUNT(Product), ALLEXCEPT(Category))

[PSB · Accepted solution]

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.

[PSB]

found the issue

[vicky_ · Accepted solution]

Try the following:

Count Column = CALCULATE(DISTINCTCOUNT(Product), ALLEXCEPT(Category))

[PSB · Accepted solution]

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.

[PSB · Accepted solution]

Column = CALCULATE(DISTINCTCOUNT('Table'[Product]),ALLEXCEPT('Table','Table'[Category]))