cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Soooma
New Member

Different calculation for each row based on a different column

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:

CategoryTurnover
AField A + Field B
BField A + Field C
CField 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

3 REPLIES 3
Soooma
New Member

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
Not applicable

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
Solution Sage
Solution Sage

Hi @Soooma ,

 

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

 

Jori

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors