Forum Discussion

jaafer's avatar
jaafer
Frequent Visitor
8 years ago

need help

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 ...
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

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,