Forum Discussion
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
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- Greg_DecklerCommunity 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.
- AnonymousNot applicable
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 - daxCommunity 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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.