Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Minimizing and Maximizing table rows(Kind of drilldown)

Hi Team,     I have employee table where I have the Employee details like Id, Name, Location details, Role and Teamlead Id and TeamLead table where I have Id, Name, Location details, and Role. My r...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous, the data looks similar to this.

Expected results are 

 

When we expand the rows it should look like this

 

 

 

Team Lead Table 

UserIdNameRole StateDistrictLocality
EMP1002TL1BackendKarnatakaBengaluruWhitefield
EMP1064TL2Full StackMaharastraMumbaiGoregaon
EMP1012TL3DevOpsMaharastraMumbaiGoregaon
EMP1068TL4AIKarnatakaBengaluruWhitefield
EMP1048TL5BIKarnatakaBengaluru

Whitefield

 

 

Team Members table

UserIdNameRole StateDistrictLocalityTeamLeadId
EMP1111EMP Name 1BackendKarnatakaBengaluruWhitefieldEMP1002
EMP1112EMP Name 2Full StackMaharastraMumbaiGoregaonEMP1064
EMP1113EMP Name 3DevOpsMaharastraMumbaiGoregaonEMP1012
EMP1114EMP Name 4AIKarnatakaBengaluruWhitefieldEMP1068
EMP1115EMP Name 5BIKarnatakaBengaluruWhitefieldEMP1048
EMP1116EMP Name 6BackendTelanganaHyderabadSecunderabadEMP1002
EMP1117EMP Name 7Full StackMaharastraMumbaiGoregaonEMP1064
EMP1118EMP Name 8DevOpsMaharastraMumbaiGoregaonEMP1012
EMP1119EMP Name 9AITelanganaHyderabadHi-Tech CityEMP1068
EMP1120EMP Name 10BackendMaharastraMumbaiGoregaonEMP1002
EMP1121EMP Name 11Full StackTelanganaHyderabadSecunderabadEMP1064
EMP1122EMP Name 12DevOpsMaharastraMumbaiGoregaonEMP1012
EMP1123EMP Name 13AITelanganaHyderabadHi-Tech CityEMP1068
EMP1124EMP Name 14BIKarnatakaBengaluruMarathahalliEMP1048
EMP1125EMP Name 15BIKarnatakaBengaluruMarathahalliEMP1048
EMP1126EMP Name 16BIKarnatakaBengaluruWhitefieldEMP1048
EMP1127EMP Name 17AITelanganaHyderabadJubilee HillsEMP1068
EMP1128EMP Name 18Full StackKarnatakaBengaluruMarathahalliEMP1064