Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AnkurSharma
Helper I
Helper 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 1
parry2k
Super User
Super User

@AnkurSharma what is the relationship? One to many or many to many? If one to many, which side is one?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.