Handling the multiple level of Hierarchy for Drill Down.

[reemapinto]

Hi,

Here is a table indicating the parent-child relationship within same table

[Refering the link(http://www.daxpatterns.com/parent-child-hierarchies/) I created Hierarchial Levels(Level 1 to Level 7)].

Id	Title	State	ParentId	Level1	Level2	Level3	Level4	Level5	Level6	Level7
1	Title1	Resolved	0	1
2	Title2	Completed	1	1	2
3	Title3	Proposed	14	12	4	8	14	3
4	Title4	Committed	12	12	4
5	Title5	Started	2	1	2	5
6	Title6	Resolved	10	12	4	8	14	3	10	6
7	Title7	Completed	4	12	4	7
8	Title8	Proposed	4	12	4	8
9	Title9	Committed	2	1	2	9
10	Title10	Resolved	3	12	4	8	14	3	10
11	Title11	Resolved	3	12	4	8	14	3	11
12	Title12	Completed	0	12
13	Title13	Proposed	2	1	2	13
14	Title14	Committed	8	12	4	8	14
15	Title15	Started	8	12	4	8	15

Now,

I'm trying to present this data in a pie chart where "hierarchy"(i.e. Level1 to Level7) is legend & "count of 'Id'" as value.

Initially in the first level only 'Ids' 1 and 12 are shown. On drill down, by clicking 'Id' 1, I'm expecting the pie chart to show 'Id' 2 alone.

But, along with Id 2 , "Blank" is also shown.

Similarly when 12 is drilled down, Id 4 and Blank is shown. On further 4 is drilled down, 7, 8 & "Blank" is shown.

How to avoid Blank ?

[sdjensen]

Hi,

I am not sure I fully understand your problem, but did you read this article at DAX Patterns? Esperially the last part where you calculate a BrowseDepth and use this to create your measures.