Forum Discussion

roopa_123's avatar
roopa_123
Helper I
4 years ago

DAX

Hi Team, I have two tables in my powerbi desktop with many to many relationship between them. I have a primary key column in tableA and another primary key column in tableB. I need to get the c...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
4 years ago

roopa_123 ,Try if this can work 

 

countrows(summarize(Table1, Table[ID],Table2[ID] ))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi roopa_123 ,

     

    Is it possible to provide some dummy data and expected results?

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.