Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I am looking for a solution here. I need the Ranging opp to be simply 1 for unique porduct codes. (Here it is summing it up)I have created a column with just "1" as Ranging opportunity here. Also, I want to be able to see the sum of the entire rows and at each hierarchy level. I am sure there must be a way out but I can't seem to find one. Can someone please help me
(Product code is Text type)
Thanks in advance!
Solved! Go to Solution.
Can you explain a bit further?
It sounds like
Ranging Opps= COUNTROWS( VALUES(QUERY1[PRODUCT_CODE]))
id the solution, but it could be I'm not understanding the issue.
Can you explain a bit further?
It sounds like
Ranging Opps= COUNTROWS( VALUES(QUERY1[PRODUCT_CODE]))
id the solution, but it could be I'm not understanding the issue.
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |