DAX Measure

[Sony]

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...

[Fowmy · Accepted solution]

@Sony 

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 🙂

Website YouTube  LinkedIn

[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

[Sony]

Thank you.  Let’s say they are related…then what would the DAX formula look like?  Assuming this below:

Table1

Region, Sales

Table2

Region, Growth%

[Pragati11]

Hi @Sony ,

Can you provide some sample data for both of your tables along with the expected output?

Thanks,

Pragati

[Sony]