Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |