need help

[jaafer]

hi  i am new to power bi.  i have a table  

table name " value entry"

entry no	entry type	purchase amount	sales amount	cost
1	purchase	10	0	10
2	Sale	0	20	10
3	sale	0	20	10
4	purchase	10	0	10

i want to get the profit value, normally i am doing with excel sum if formula to get the total cost and i will deduct the total cost of entry type sale. Please help.

[v-sihou-msft]

@jaafer

I can't get your logic for Profit exactly. But, to calculate total cost, you can create a measure like: 

Total Cost = SUM(ValueEntry[Cost])

For the total cost of entry type sale, you can write a measure like: 

Total Cost = CALCULATE(SUM(ValueEntry[Cost]),FILTER(ALL(ValueEntry),ValueEntry[entry type]="Sales"))

Regards,