Count of column by another column in another table

[Guneet_B21]

Hi everyone,

I am trying to create a measure to calculate the total number of ShipmentID's against all the Consol IDs.

Kindly help me with the same

Tables: 

 

Expected Result

[Prateek97]

Hi @Guneet_B21 ,

Can you please explain on what basis are the two tables connected and how the count is calculated. Because I dont see any common values.

Is it based on the JS_PK Column? If yes, can you please provide the sample data so that I can see the values properly.

[Guneet_B21]

Hi @Prateek97 ,

the above 2 tables are just sample tables i created to post the question,

we have a third table which connects these two tables as they cant directly be connected,

therefore the 2 PK columns and the connector is generator directly through our software to create a binding table

[Prateek97]

Hi @Guneet_B21 ,

If the tables are already connected then putting a simple count measure against the ConsoleID column from the connected table should work.

If not, please share some good sample data from the 3 tables, that I can copy and try. Please dont share a screenshot.

[Guneet_B21]

I am getting the total count in graphs but when im trying to put the count in table it is showing "1" 
i wanna see the total shipments against a particular consol in table