Need Help with DAX

[Anonymous]

Hello, Hope you all are doing great.

I am stuck in one conditional DAX formula 
I have one table in which I have 5 Columns trdr1, trdr2, week, trdr1 prft and trdr2 prft.

Now I want to calculate profit based on some condition like if trdr1 = 51 and week = 1 than calculate sum of trdr1 prft
and if trdr2 = 51 and week =2 (Suppose week =2 is not present where trdr1 =51 ) than calculate sum of trdr2.

If we have matching values like trdr1 = 51 and week = 1, trdr2 = 51 and week = 1 than it should consider value from trdr1 prft

I hope I have explained problem statement fully.

Please help me with this problem it will be very helpful to me

Thanks in advance

[Ajendra]

Hello,

Share some demo data along with the desire output.

Thanks!!

[Anonymous]

Thanks for your reply,
This solution is static one, I want dynamic measure, Like instead of using trdr1=51 and week =1, I want to sum for all trdrs and weeks.

[eliasayyy]

not sure if i got you correctly but you could try using if or switch 

Condition = 
SWITCH(
     TRUE(),
     AND('table'[trdr1] = 51 , 'table'[week] = 1) , sum('table'[trdr1]),
     AND('table'[trdr2] = 51 , 'table'[week] = 2) , sum('table'[trdr2]),
     AND('table'[trdr1] = 51 , AND('table'[week] = 1, table'[trdr2] = 51)) , sum('table'[trdr1]),