DAX for unique values and sum at the end of each level of hierarchy

[Anonymous]

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!

[rbriga · Accepted 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.