Hierachies and Filtering

[cmcgo3]

This is probably a simple fix; but I cannot quite get it. 

Ultimately, I am trying to create visual (preferably gauge) to show "Andrew Phillips" percentage as well as separate visual to compare the others included on his "Team F", (B. Davis and J. Davis) and thirdly, a visual to compare others included in his region "Northeast", (B. Davis, Jackson, Williams, J. Davis, and Smith).

In attached file, if I click on "Andrew Phillips" who is on Team "F" and region "Northeast", the first visual is correct; percentage is 33.77%.  In the next visuals down, titled "Region", I would like to calculate the percentage of all others within that region which would be Davis, Jackson, Williams, Davis, and Smith which should calculate to 24.73%.

In the final visual, I would like to calculate the percentage of all others within that team which would be B. Davis and J Davis, which should calculate to 22.78%.

hiearchy

[Anonymous · Accepted solution]

Hi mh2587 ,thanks for the quick reply, I'll add more.

Hi @cmcgo3 ,

The detailed content can be found in the attachment.

Best Regards,
Wenbin Zhou

[cmcgo3]

Apologies...done

[mh2587]

Please enable the access public to download the pbix file