Forum Discussion
Solved
DAX Measure
Trying to figure out how to create a measure that performs a calculation for each region in the dataset then rolls it together. For example, table 1 has Region and Sales (i.e. DEN, 1000) and table 2...
The following measure should work with a relationship:
New Measure = SUMX( 'Table 1', 'Table 1'[Sales] * RELATED('Table 2'[Growth]) )________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply đŸ™‚
Pragati11
Super User
Super UserHi Sony ,
I think you will first need to have a realtionship between both of your tables, otherwise you can-not use individual columns from 2 tables to do a calculation.
Another way is using LOOKUPVALUE dax function, by getting one of the columns like SALES from your Table 1 to Table2 against regions.
Thanks,
Pragati
