Forum Discussion

AnkurSharma's avatar
AnkurSharma
Helper I
3 years ago

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