Forum Discussion

Gopinath_iyer's avatar
Gopinath_iyer
Helper II
5 years ago

Hierarchy and filter

Hello Friends,   i have a data set like below   Agents Policies sold Entity key Parent key A 13 1   B 22 2   C 5 3 1 D 20 4 3 E 20 5 2 F 10 6 2   Th...
Need Help
MFelix's avatar
MFelix
Super User
5 years ago

Hi Gopinath_iyer ,

 

This is a common parent child pattern.

 

You need to follow the dax pattern show in this blog post by SQLBI guys.

 

If you need any assistance please get back to me.

  • Gopinath_iyer's avatar
    Gopinath_iyer
    Helper II
    5 years ago

     

    Thanks,

     

    i have implemented this and the hierarchy is coming fine, but when i use the Agent filter it is not working properly.

     

    e.g, when i select 'C' in Agent filter

    i am getting

    AgentsPolicies sold
    A25
        C25

     

    but i want 

    AgentsPolicies sold
    C25
        D20

     

    basically i want to see the selected agent and his downline with their respective policies sold counts, but i m getting the selected agent and the upper level with the policies sold count of selected agent for all the agents.