DAX

[roopa_123]

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!

[roopa_123]

Hi Stephan

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

[amitchandak]

@roopa_123 ,Try if this can work 

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

[roopa_123]

@amitchandak : That didn't work 😔

[Anonymous]

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.