How to use selected Parameter/Slicer Value to create custom column?

[SandipTalekar]

Hi,

I have some sample data with variables as follows

Code	Brand	NTS Change	GP$ Change	COGS Change
1	Brand1	-45.11	-25.84	-19.28
2	Brand1	-26.44	-12.41	-14.03
3	Brand1	-153.74	-124.78	-28.96
4	Brand1	-578.47	-388.2	-190.28
5	Brand1	-1.04	-0.95	-0.1
6	Brand2	-261.85	-80.81	-181.04
7	Brand2	-74.26	-48.39	-25.86
8	Brand2	2.26	2.26	0
9	Brand2	-516.25	-342.73	-173.52
10	Brand2	-823.52	-602.56	-220.96

I have created another table for measures viz. NTS, GP$, COGS and used as slicer shown below.

I need to create a custom column 'Final Change' in the data itselft which is either NTS/GP$/COGS change based on measure selected. I have call out the value of measure selected and used it in the IF statement to return the change but nothing works.

Someone please help me with the solution.

[v-yadongf-msft]

Hi @SandipTalekar ，

In order to better understanding your demands and give the right solution, can you tell me the calculation logic of your measure and what's your expected output ?

Thanks for your efforts & time in advance.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SandipTalekar]

Hi Yadong Fang,

Hope you are doing great.

It would be difficult for me to create sample output in Power BI. Hence I am attching the sample output created in excel which I am trying to replicate in Power BI.

The objective is that I have 3 measures vis NTS Change, GP$ Change & COGS Change. I need to create a bar chart with any one of the change. THe measure selected is depend on the end user. 

Basically I need a dropdown for the above mentioned measures and the bar chart need to update based on selection.

Hope this clear and sorry for inconvenience.

Regards,

Sandip Talekar