How to sum using expression

[Maciej29]

Hello,

My question is how to sum it using Edit expression below table. My goal is create chart when i can see sum of every request but also can see divided per monthly impact.  Hope it's clear to understand my view. Thanks in advance.

request	Impact nov'19	Impact dec'20	Impact jan'20
686670349	$334	$22422	$2111
354435843	$12	$7013	$233
122329837	$222	$734	$905

[y_grynechko]

Hi,

did you try using pivot table? Or bar chart with two dimensions?

[Maciej29]

I'm looking for something like this. Please see example (based on .ppx file) . How to sum it up if needed info is in 3 different columns. 

[y_grynechko · Accepted solution]

Like this?

[Maciej29]

I have an issue with set up this chart. How to put "request" to Measures as I have impact  in Measures. Could you explain how to put data properly?

Much appreciated for your support.

[y_grynechko]

[Maciej29]

How have you put impact as single value as they are in 3 different columns ?

[y_grynechko]

Can you share the data you load? I think you have a different data model. 

[Maciej29]

My aim is to see impact for every month divided by department . (not request, my mistake sorry for this). Only these columns I use.  Sequence is the same as below.

request	Impact nov'19	Impact dec'20	Impact jan'20	department
686670349	$334	$22,422	$2,111	AP
354435843	$12	$7,013	$233	GL
122329837	$222	$1,734	$905	PO
142669837	$218	$2,223	$905	PO
142669938	$334	$22,422	$2,111	AP
145559830	$12	$7,013	$233	GL
177669840	$10,100	$672	$1,024	IA