Forum Discussion
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 has Region and Growth (i.e. DEN, 8%). For each region, multiply sales X growth (1080 in the example) then sum all these together. Table 1 and Table 2 are not related. Many thanks...
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 🙂
5 Replies
- Fowmy
Super User
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
Hi 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
