Dashboard for Multiple Tables

[Anonymous]

Hi all
I have the following measures separate for separate tables. These tables capture the total requests that were sent to the various units. Why is used personalId is because that field is never empty so is the perfect field to use to capture the number of requests. I am representing the number of requests say, per country or Department etc... and I have a dimension table for country and department etc.. that are connected to all the Units in a 1 to many relation. 
To represent the total number of requests, per country, department etc on a visual,  I would need to combine all the measures. How do I do it, please? And if theres a more optimal way of doing it other than this method I am open to it

Measure1 = COUNT('Unit1'[PersonalId]

Measure2 = COUNT('Unit'[PersonalId]

Measure3 = COUNT('Unit3'[PersonalId]

Measure4 = COUNT('Unit4'[PersonalId]

[v-yingjl · Accepted solution]

Hi @Anonymous ,

Since the dimension table has relationships with other tables, you can try to sum all these measures directly to show the total count in the dashboard.

Total count = Measure1+ Measure2 + Measure3 + Measure4

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

You should append all unit tables to create just one unit table.  That way only 1 measure will be required.

[Anonymous]

@Ashish_Mathur the tables have completely different structures

[selimovd]

Hey @Anonymous ,

what is your question?

Where are you struggling?

Best regards

Denis

[Anonymous]

I am sorry I did not give my attempt at least. I have rephrased the question 
Thanks