Sum Columns

[alejandrodiaz]

Hello, I am new to Power Bi, and I wanted to see if you could help me solve this problem.

I have a dashboard that I consult from a table that is like this:

id	Consultant	C1	Support Consultant	SC1
1	Juan	8
2	Pedro	4	Alex	8
3	Charly	10	Fer	5
4	Julio	8	Alex	4
5	Alex	6	Charly	3
6	Pedro	7	Julio	4
7	Juan	7	Fer	3
8	Fer	5

What I am trying to do is, add the occupation of a consultant, it does not matter if it is a regular consultant or a support consultant, you must add the c1 with the of sc1, something like this should remain on a dashboard....

I hope I have explained myself

Dashboard Column Chart

15	11	13	12	18	13
Juan	Pedro	Charly	Julio	Alex	Fer

[v-kkf-msft · Accepted solution]

Hi @alejandrodiaz ,

Please create a new table.

NewTable = 
ADDCOLUMNS (
    DISTINCT (
        UNION ( VALUES ( 'Table'[Consultant] ), VALUES ( 'Table'[Support Consultant] ) )
    ),
    "Sum_C",
        CALCULATE (
            SUM ( 'Table'[C1] ),
            FILTER ( 'Table', 'Table'[Consultant] = EARLIER ( [Consultant] ) )
        )
            + CALCULATE (
                SUM ( 'Table'[SC1] ),
                FILTER ( 'Table', 'Table'[Support Consultant] = EARLIER ( [Consultant] ) )
            )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@alejandrodiaz , Unpivot all 4 columns(last), then use replace value the attribute convert %sc1 to % c1. And the pivot again. you should get two columns