Not able to add Measure values to a manually created table

Question

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 Answer

Hi&nbsp;ricky23&nbsp;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.&nbsp;Patrick

Forum Discussion

Not able to add Measure values to a manually created table

2 Replies

Related content

Need help creating a measure

Help to create DAX Measure

Adding a row manually to manually created table

Auto date/time vs manually created hierarchies

Create a Manual Refresh Visual Button