how to create simple measure for summation

[Anonymous]

hi,

how can i write a formula for measure to calculate total income & total expenses for the following data in the table below?

then, i'd also like to do a simple measure to calculate the profit & loss (total income - total expenses) for them.

tks, -nik- 

[Anonymous]

Hi,

Create measures:

Total Income = CALCULATE(SUM(Value), Category = "Income")

Total Expense = CALCULATE(SUM(Value), Category = "Expense")

Revenue = [Total Income ] - [Total Expense]

Hope this helps!

br,

Adrian

[Anonymous · Accepted solution]

many2 tks, adrian.