cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

SUM a measure to a column

Hi,

i want to sum these 2 values but first column(A) is a measure and second is a column(B).

How can i do that?

Result:

ColumnC = (A+B) 12882,29 + 5242,9

Thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

If it is just in the table you want it done, then I would change column B into a measure

`Sum Ore impiegate su assengnabili = SUM(factTable[Ore impiegate su assengnabili])`

And then I would make a measure C which is the sum of the two first measures:

`C = [Sum Impiegate su assegnate] + [Sum Ore impiegate su assengnabili]`

If you want it in the factTable, then I would create a calculated column with measure A, and a calculated column which hold the sum of A and B.

3 REPLIES 3
Anonymous
Not applicable

If it is just in the table you want it done, then I would change column B into a measure

`Sum Ore impiegate su assengnabili = SUM(factTable[Ore impiegate su assengnabili])`

And then I would make a measure C which is the sum of the two first measures:

`C = [Sum Impiegate su assegnate] + [Sum Ore impiegate su assengnabili]`

If you want it in the factTable, then I would create a calculated column with measure A, and a calculated column which hold the sum of A and B.

Anonymous
Not applicable

I cant transform it in a measure

Anonymous
Not applicable

Can you then make column B into a measure? And then add the two measures into measure C?

Announcements