Forum Discussion

LisaB's avatar
LisaB
Icon for Helper III rankHelper III
8 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 ...
Need Help
  • SivaMani's avatar
    SivaMani
    8 years ago

    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

LisaB's avatar
LisaB
Icon for Helper III rankHelper III
8 years ago

Hi SivaMani,

 

Thank you, that worked fine for me!

 

I want to make an additional sum, just like the one for SalesPerson. I followed your steps but I cannot activate one of the relationship.

 

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
8 years ago
LisaB
The created relationship depend on each other. It like a loop.

That's why you got the error.