Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
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
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.
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
User | Count |
---|---|
97 | |
87 | |
78 | |
74 | |
70 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |