Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic slicer columns

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 

  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    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.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable

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

       

      Work Item IdConfidenceSP MD
      10High5
      11High3
      12Low110
      13High3
      14Medium5
      15High3
      16Low10
      17Low5
      18Medium5
      19Medium5
      20Low5
      21High10
      22Medium10
      23High3
      24Medium5
      25Medium10
      27Medium10
      28High3
      29Medium10
      30High3
      31High3
      32Low10
      34Medium10
      35Medium5
      • dax's avatar
        dax
        Community Support

        Hi Anonymous , 

        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.