Forum Discussion
AnkurSharma
3 years agoHelper I
table name not appearing when summarizing
Hi Guys,
I have 2 tables, PIM and Baan , I created a relation between these two column , and i created a Over due Po table which is summary table of PIM and Baan , i am not able to see Baan table in Dax.
Overdue PO =
FILTER(
SUMMARIZE(
'PIM',
'PIM'[Co],
'PIM'[Description],
'PIM'[Item],
'PIM'[Order#],
'PIM'[Line],
'PIM'[Due],
'PIM'[Ldtm],
'PIM'[MIOQ],
'PIM'[Oint],
'PIM'[PPC],
'PIM'[Qty],
'PIM'[REM],
'PIM'[SafetyStk],
'PIM'[Sftm],
'PIM'[Otyp],
"Key", 'PIM'[Co] & 'PIM'[Item] & 'PIM'[Order#] & 'PIM'[Line]
),
'PIM'[Co] IN {220,221,410,420,421,422,423} &&
'PIM'[Otyp] IN {"PO"} &&
RELATED('Baan Consolidated Data'[ref_a])
)
I tried using Related but no luck . Please help. I am confused why name of baan table is not coming here. appreciate your help and time.
1 Reply
- parry2kSuper User
AnkurSharma what is the relationship? One to many or many to many? If one to many, which side is one?