How do multiple a variables in one data source, and one other in an other data source

[Anonymous]

Hello,

I wonder.. I have a parameter that i wanna mulitiple. with another parameter in anohter data set, how do I do that? 

Dataset1           Dataset2

a                      b

and the formua i want to have is: formula a=a*b*0.5

and i type that in in dataset1, by addanig a new colomn.

and i type : new colomn = dataset1[price]*0.5*dataset2[fees]

and I got this error: message  "a single value for colomn dataset2 cannot be determined. thi can happend when a measure fomula refers to a  colomn that cointasn many values withou specifytin an aggregation such min,max,count, sum to get a single result.

How do I do this???

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

You may try a method below if  the two datasets dont have a relationship between:

First in both datasets,create an index column;

Then create a column as below:

Column = 'Table 1'[Value]*0.5*CALCULATE(MAX('Table 2'[Value]),FILTER('Table 2','Table 2'[Index]='Table 1'[Index]))

For details ,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , how are you moving data from one table/dataset to another. The few ways are

//In dataset 1 from dataset 2

//when Dataset 1 and dataset 2 has Many to 1 reation

New colum dataset 1 = dataset1[price]*0.5* RELATED('dataset2'[Fee])

//In dataset 1 from dataset 2

//when Dataset 1 and dataset 2 has Many to 1 reation why giving a key column

Month Name = dataset1[price]*0.5*  LOOKUPVALUE('dataset2'['dataset2'[Fee],'dataset2'[key],'dataset1'[key])

//any direction just take care of filter join and aggeragtion - minx,maxx,xountx,sumx

New in dataset 1 =dataset1[price]*0.5*    maxx(FILTER(dataset2,dataset2[Id]=dataset1[Id]),'dataset2'[Fee])

[pranit828]

HI @Anonymous 

Determine how are these two tables joined and either create a DAX LOOKUPVALUE formula to get what you need.

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

[CNENFRNL]

I think it's necessary to establish a relationship between two datasets to achieve what you want.