Two Tbl combine IF statement - DAX

[Anonymous]

Hi Team,

I have two table and created relationship both ID's and trying DAX if statement , can you help me.

formula is = if (table 1 .ID=Table 2.ID ,(A/C)*(G*B),null)

Thanks,

KV's

[v-yalanwu-msft · Accepted solution]

Hi @Anonymous ,

According to your description, you could create new table and measure then change ralationship, the following formula to create a measure and table :
step 1: Add table(newTable)

NewTable =
var _Table1=SELECTCOLUMNS('Table1',"ID",[ID])
var _Table2=SELECTCOLUMNS('Table2',"ID",[ID])
return DISTINCT UNION(_Table1,_Table2)

step2:Add measure(The null returned by this measure is text format. If you want to change to number format, change "null" to blank()  )

value =
VAR _a =
    DIVIDE ( MAX ( 'Table1'[A] ), MAX ( 'Table1'[C] ) ) * SUM ( Table2[G] )
        * SUM ( Table1[B] )
RETURN
    IF ( MAX ( 'Table1'[ID] ) = MAX ( 'Table2'[ID] ), _a, "null" )

Step3：Change relationship

The final output is shown below:

Best Regards,
Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , New column in Table 1

divide(Table1[A] , Table1[C])*(sumx(filter(Table2, Table2[ID]= Table1[ID]), Table2[G]) *Table1[B])