Combining Measures

[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]

[Shahfaisal]

Assuming that:
1. The table structure is the same for each of the unit tables
2. You have the ability to transform/prep data using an ETL (extract, transform, load) tool
You can "UNION" all the unit tables and create a single table with an extra column that shows the unit # (unit 1, unit 2, etc.). In Power BI, you can just have one DAX calculation built using this table. 

[Anonymous]

Hi @Shahfaisal both assumptions 1 and 2 are not possible to me. The tables are on SharePoint and the structure cannot be altered 

[Shahfaisal]

Then what you are doing is not a bad option, unless you are willing to append (UNION) all the unit tables in Power Query into a single table. You will need to weigh the pros and cons using this approach though. For example, if you are planning to build hundreds of such DAX caulcations, it would be advisable to create a single unit table using Power Query, but if you are only creating a few calculations, it may not be worth the effort. Moreover, Power Query can be a bit slow when dealing with cloud data sources.

Bottom line is that you don't have a lot of great options to choose from.

[Anonymous]

@Shahfaisal My question is what function/measure can I use to combine all the MEASURES into one single measure that I can use with the Dimension tables so that the KPIs represent all tables.
Please maybe if you give like an example with the measures I gave above I'll be very grateful 

[Shahfaisal · Accepted solution]

MeasureTotal = Measure1 + Measure2 + Measure3 + Measure4