How to calculate two columns based on another?

Question

Hi all,&nbsp;Looking to calculate two values based off of another column.&nbsp;Example:I want to calculate the sales of shop1 and shop2 but only if it is in New York.IDCityShop1SalesShop2Sales1New York40302Chicago20353New York50104Chicago1010&nbsp;So the result should be in a new column:TotalNewYorkSales700600&nbsp;Any help appreciated.

mahoneypat · Accepted Answer

I encourage you to unpivot your data, but, if not, you can try use this measure expression
&nbsp;
NY Sales = CALCULATE(SUMX(Table, Table[Shop1Sales] + Table[Shop2Sales]), KEEPFILTERS(Table[City] = "New York")) + 0
&nbsp;
Regards,
Pat

Forum Discussion

Related content

Calculate new column based on another column's text

TMDL - calculated column

Sort by another column

Direct Lake Model - Calculated Column/Tables

calculated column using another table scan