Forum Discussion

LisaB's avatar
LisaB
Icon for Helper III rankHelper III
9 years ago
Solved

Sum of values in same chart

Hi,

 

I am pretty new to Power BI and learing more and more every day.

 

I am creating a report that will show me sales values depending on sales person, customer type etc. To do this I am using amounts from the ERP system where sales invoice lies in one table and sales credit amound lies in another table. This means I have to queries.

 

What I want to do: Sales person total amount = sales invoice amount - sales credit amout. I want to visualise each sales person's amount in the same chart.

 

Example data

https://1drv.ms/x/s!AnO0yKcIgtwGgcsBzanKGyX-D4riIA

 

 

Any suggestions?

 

Thank you!

Lisa

  • LisaB,

     

    1.Create a table to have Sales person's code,

     

    SPC = DISTINCT(SalesInvoice[Salesperson_Code]) 

     

    2. Create a relationship like below,

     

     

    3.Create a measure for Total Amount,

     

    TA = SUM(SalesInvoice[Invoice]) - SUM(SalesCredit[Credit]) 

     

    That's it

7 Replies