Forum Discussion

cmcgo3's avatar
cmcgo3
Icon for Helper II rankHelper II
1 year ago
Solved

Hierachies and Filtering

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's avatar
    Anonymous
    1 year ago

    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

3 Replies

  • Please enable the access public to download the pbix file

  • Anonymous's avatar
    Anonymous
    Not applicable

    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