Advice on report design

Usually, the way to handle this is to append your data sources together so that you don't need more measures. You may want to add a division column to each source before appending (if one doesn't already exist) so that you can easily slice by that column to return the data from one division or the other.

Hi Anonymous ,

Are the column names and structure the same for both tables? Please make sure this.

Then you can add a divisions column to both tables to differentiate between the two tables.

For DAX you could use UNION() function and for Power Query you could use append feature.

https://docs.microsoft.com/en-us/dax/union-function-dax 

https://docs.microsoft.com/en-us/power-query/append-queries 

Best Regards,

Jay