March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to Solution.
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.
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.
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 |
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |