Skip to main content
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

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 = 
        "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. 

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

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.