Forum Discussion

Gopinath_iyer's avatar
Gopinath_iyer
Icon for Helper II rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper II rankHelper 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.