Forum Discussion
Creating a measure for same metrics but different dimensions
I have a collection of tables that have various cuts of the same metrics using different dimensions. Simplified example: Is there a way I can create a single measure to calculate the averag...
amitchandak
Super User
Super Userdogbob , Add one additional column in all table Dimension name and then append them in power query
and then you can have one common measure
Divide(Sum(Table[Ad Spend]), Sum(Table[Leads]) )
Thanks for the suggestion -- I had considered this option, but isn't appending tables with different dimensions generally considered a bad practice, since it results in columns that contain mostly blank values? For example, using the same data as above, 2/3rds of the region column would be null, since 2 of the 3 tables don't have any data associated with region.