topic If table A has "text" then calculate sum on 2 different tables in DAX Commands and Tips

If table A has "text" then calculate sum on 2 different tables

Anonymous — Thu, 07 Dec 2023 22:24:11 GMT

Hello,

I have 2 tables. Table A and Table B

If Table A contains "Accept" then it should equal calculate(sum(Table A Column C) - calcuatesum(Table B Column D)

If Table A does not contain "Accept" Then it should equal 0.

I've tried using IF/IS IN SCOPE,

I've tried using the filter function

sumx filter

All are giving me sintax errors. Anyone know the best way to figure this out.

Thank you,

Re: If table A has "text" then calculate sum on 2 different tables

Anonymous — Mon, 11 Dec 2023 06:12:12 GMT

Hi Anonymous ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: If table A has "text" then calculate sum on 2 different tables

Anonymous — Wed, 13 Dec 2023 14:10:31 GMT

Awarded Carrier Linehaul comes from a differrent table then Linehaul. So if this row = Tender Reject I want Spend Variance Measure to = 0

If Tender Accept, it should calucate as it is below.

So ideally should be a simple IF statement but I keep getting errors.

Let me know if this helps.