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 noentry typepurchase amountsales amount cost
1purchase10010
2Sale02010
3sale02010
4purchase10010

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.

 

1 Reply

  • 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,