Different calculation for each row based on a different column

[Soooma]

Hello experts

I am new to Power BI and have a question how to implement the following scenario:

I have a dashboard in which the turnover category is displayed in the first column and a column in which the turnover for the category is displayed. Both come from different tables. However, the calculation is not the same for each category. How can I make a calculation based on the category shown in column 1? Simplified example:

Category	Turnover
A	Field A + Field B
B	Field A + Field C
C	Field A + Field C - Field B

It is not clear to me how I can build a different calculation for each row in column "Turnover" based on column "Category".

I have tried to work with a SWITCH statement. But that doesn't work somehow, but it still uses the same formula for each line.

Thank you for your help

[Soooma]

Hello together

Yesterday I found a solution that suits me in a different way. Thank you very much for your feedback.

Best Regards 

Soooma

[Anonymous]

Hello,

Can you please provide some sample data? This will be of use for anyone trying to help you to achieve the desired outcome.

Looking forward to the reply.

Thanks.

[jppv20]

Hi @Soooma ,

Could you provide the statement you tried to use? Also, would you like to create a calculated column or a measure?

Jori