cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
reemapinto Frequent Visitor
Frequent Visitor

Handling the multiple level of Hierarchy for Drill Down.

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)].

 

IdTitleStateParentIdLevel1Level2Level3Level4Level5Level6Level7
1Title1Resolved01      
2Title2Completed112     
3Title3Proposed141248143  
4Title4Committed12124     
5Title5Started2125    
6Title6Resolved101248143106
7Title7Completed41247    
8Title8Proposed41248    
9Title9Committed2129    
10Title10Resolved3124814310 
11Title11Resolved3124814311 
12Title12Completed012      
13Title13Proposed21213    
14Title14Committed8124814   
15Title15Started8124815   

 

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 ?

1 REPLY 1
sdjensen Senior Member
Senior Member

Re: Handling the multiple level of Hierarchy for Drill Down.

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.

/sdjensen