Forum Discussion
Trouble Linking Data Entries Between Two Queries
Hi Anonymous ,
Would you please create a relationship between table1 and table2 by 'Event Id' column? And you can use the following two measure for your chart:
Incidents with Lane Blockage = COUNT(Table1[Event Id]) Incidents with Motorists Assist On Scene = CALCULATE(COUNT(Table1[Event Id]), FILTER(RELATEDTABLE(Table2),Table2[Responder Type] = "Motorist Assist"))For more details ,please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EetDHgCtdZhOukrTNKAIw94BncRmW3o5A1PymZqwF8f8Ig?e=WqwDe0
If this post help, please consider accept it as the solution to help other member find it more quickly.
Best Regards,
Dedmon Dai
Hi Anonymous ,
Would you please create a relationship between table1 and table2 by 'Event Id' column? And you can use the following two measure for your chart:
Incidents with Lane Blockage = COUNT(Table1[Event Id])
Incidents with Motorists Assist On Scene = CALCULATE(COUNT(Table1[Event Id]), FILTER(RELATEDTABLE(Table2),Table2[Responder Type] = "Motorist Assist"))For more details ,please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EetDHgCtdZhOukrTNKAIw94BncRmW3o5A1PymZqwF8f8Ig?e=WqwDe0
If this post help, please consider accept it as the solution to help other member find it more quickly.
Best Regards,
Dedmon Dai