Dynamic slicer columns

[macinr]

Hi,

I have a table 

I want calculate 3 new columns. 

Max = Story point * Low confidence multiplier

Min = Story point * high confidence multiplier

Medium = if (confidence = High then Story Point * High confidence multiplier
  Elseif confidence = Medium then Story point * medium confidence multiplier

  Else Story point * medium confidence multiplier

I then want to dynamicaly update through slicer the confidence multiplier for each level of confidence, hence I created three disconnected parameter tables

The result should look more or less like this, where with each change to confidence I would see update on the chart

When I tried to measure with following formula, I get blank results. 

MD Minimum M = SUMX('Work Items - Today',
                'Work Items - Today'[SP MD] * SELECTEDVALUE('High confidence multiplier'[High confidence multiplier]))

I also tried a column

MD Minimum = 'Work Items - Today'[SP MD] * SELECTEDVALUE('High confidence multiplier'[High confidence multiplier])

but also blank result

What am I doing wrong?

Thanks for help

Best

Marcin 

[Greg_Deckler]

Can you post that sample data as text? Also, note that you cannot have a column update dynamically based on a slicer. Once you introduce interactivity into the equation, you need to use measures.

[macinr]

Here you are. I tried both, none work, but good to know, columns won't work, already an important hint 🙂

Work Item Id	Confidence	SP MD
10	High	5
11	High	3
12	Low	110
13	High	3
14	Medium	5
15	High	3
16	Low	10
17	Low	5
18	Medium	5
19	Medium	5
20	Low	5
21	High	10
22	Medium	10
23	High	3
24	Medium	5
25	Medium	10
27	Medium	10
28	High	3
29	Medium	10
30	High	3
31	High	3
32	Low	10
34	Medium	10
35	Medium	5

[dax · Accepted solution]

Hi @macinr , 

I am not sure your problem, you could refer to my sample for details. If this is not waht you want, please correct me and inform me more detailed information.

Best Regards,
Zoe Zhi

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