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 count of records on a visual but that count should be combination of the primary keys from table A and tableB.
For example the primarykey from tableA is 'ABC' and primarykey from tableB is '123', then my count on the visual should consider the combination of 'ABC123' as single column and give the count value.
How can I achieve this using DAX? Any help is appreciated!

Thanks in advance!

Need Help
Show and Tell

4 Replies

      • 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.

  • roopa_123's avatar
    roopa_123
    Helper I
    4 years ago

    Hi Stephan

    I will try to provide when I get back to work on this topic again.  Thanks for your help!!