How to create a measure that will count to the first and second level hierarchy?

[Anonymous]

I have a table with three hierarchy columns. I want to count the number of times the third event occurs under second hierarchy and count the number of times that second event occurs under first hierarchy. For example:

Table1:

Hierarchy_1	Hierarchy_2	Hierarchy_3
A	a	jack
A	a	sam
A	b	sam
A	b	rob
B	b	rob
B	c	jack
B	b	sam
B	b	ken
C	d	ken
C	d	ken
C	a	sam
C	a	sam

I want the following result:

Hierarchy_1	Hierarchy_2	Hierarchy_3	Count
A	a	jack	1
A	a	sam	1
A	b	sam	1
A	b	rob	1
B	b	rob	1
B	c	jack	1
B	b	sam	1
B	b	ken	1
C	d	ken	2
C	a	sam	2

[amitchandak · Accepted solution]

@Anonymous , to me this seems simple count in tbale visual

Count(Table[Hierarchy_3])

or you can try

Countrows(summarize(Table, Table[Hierarchy_1], Table[Hierarchy_2], Table[Hierarchy_3]) )