Forum Discussion

ArvindJha's avatar
ArvindJha
Icon for Helper III rankHelper III
1 year ago

Create a single table many to many relationship using DAX

Hi all,   I want to create single table out of two tables with many to many relationship using DAX , LOOKUP and RELATED does not work. For time being i have created relationship between them but i...
Need Help
Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

ArvindJha 

Create a New Table

CombinedTable =
SUMMARIZE(
'VISIT_TABLE',
'VISIT_TABLE'[PERSON],
'VISIT_TABLE'[VISIT],
'VISIT_TABLE'[WEIGHT],
"HEIGHT", 
CALCULATE(
MAX('HEIGHT_TABLE'[HEIGHT]),
TREATAS(
VALUES('VISIT_TABLE'[PERSON]),
'HEIGHT_TABLE'[PERSON]
)
)
)

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

  • ArvindJha's avatar
    ArvindJha
    Icon for Helper III rankHelper III
    1 year ago

    Thanks for the response Kedar , output is as below , it takes only the max height 140 and ignores 139 for Person A which is not the expected outcome