How to create sum functions for graphs?

[UsePowerBI]

Hello

I have a table like:

Product, Client, Price, Profit, Units, etc

I want to calculate some sums eg:

1) sum of units per product

2) sum of units per client

3) sum of profits per client

etc

How can I calculate these and then how can I put them in a graph like:

1) x axis = product, y axis = sum of units per product

2) x axis = client, y axis = sum of profits per client

Thanks!

[v-shex-msft · Accepted solution]

HI @UsePowerBI,

You can try to use the following measure formulas if they meet your requirement:

Measure 1 =
CALCULATE (
    SUM ( Table[Unit] ),
    ALLSELECTED ( Table ),
    VALUES ( Table[Product] )
)

Measure 2 =
CALCULATE (
    SUM ( Table[Unit] ),
    ALLSELECTED ( Table ),
    VALUES ( Table[Client] )
)

Measure 3 =
CALCULATE (
    SUM ( Table[Profit] ),
    ALLSELECTED ( Table ),
    VALUES ( Table[Client] )
)

If above not help, please hare some dummy data to test:
How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Tahreem24]

@UsePowerBI ,
Create different measures like:

sum of units per product = CALCULATE(SUM(Table[Unit]),ALLEXCEPT(Table,Table[Product]))

sum of units per client = CALCULATE(SUM(Table[Unit]),ALLEXCEPT(Table,Table[Client]))

sum of profits per client = CALCULATE(SUM(Table[Profit]),ALLEXCEPT(Table,Table[Client]))

And put them in charts.