Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
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.
found the issue
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.
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |