Not able to add Measure values to a manually created table

[ricky23]

So, I manually created a table that looks like this

Name of the Pipeline	Report Name	Amount
ABC	A1
DEF	B2
GHI	B3

Now, I have created measure values for each pipeline. SumofABC, SumOfDEF and SumOfGHI

How do I add these values to the Amount Column?

Such that the Output is

Name of the Pipeline	Report Name	Amount
ABC	A1	=SumofABC
DEF	B2	=SumofDEF
GHI	B3	=SumofGHI

[pa_trick67 · Accepted solution]

Hi @ricky23 

Have you tried the switch function.

Kind of :

Switch(values(Name of the Pipeline);"ABC";SumofABC;"DEF";SumofDEF;"GHI";SumofGHI)

If it solves your issue please mark as solution.

Patrick

[v-lili6-msft · Accepted solution]

HI, @ricky23 

You need to create a calculate column for Amount by IF or SWITCH Function like pa_trick67 said.

https://radacad.com/measure-vs-calculated-column-the-mysterious-question-not

Regards,

Lin

[pa_trick67 · Accepted solution]

Hi @ricky23 

Have you tried the switch function.

Kind of :

Switch(values(Name of the Pipeline);"ABC";SumofABC;"DEF";SumofDEF;"GHI";SumofGHI)

If it solves your issue please mark as solution.

Patrick