Forum Discussion
Creating impact calculator
Certainly , ill be happy to.
Please have a look at example already provided and formula that goes into impact column for each row.
=($D$9-$D2)/($B$9-$B2))-$C$9
| A | B | C | D | E | |
| 1 | Name | Freq | Result | ttls | Impact |
| 2 | name 1 | 10 | 300 | 3000 | -3.06131 |
| 3 | name 2 | 15 | 257 | 3855 | 0.679559 |
| 4 | name 3 | 7 | 652 | 4564 | -21.6475 |
| 5 | name 4 | 50 | 217 | 10850 | 27.31679 |
| 6 | name 5 | 4 | 364 | 1456 | -3.15207 |
| 7 | name 6 | 24 | 150 | 3600 | 24.7367 |
| 8 | name 7 | 23 | 329 | 7567 | -13.9368 |
| 9 | 133 | 262 | 34892 |
The principle is that we are taking a specific user, process (Row 2 example) and calculating the difference between total weighted average results and the same, but without observed process or user.
In the example above, we can see weighted average of 262 seconds (C9) and in E2 we can see how much seconds would this result change, if we remove Name 1 from the total calculation. This is giving us the impact of this user/process.
I hope this makes it clear.
Regards
Hi - Any luck in solving this? Trying to make the same sort of measure.
Thanks.
Hi Anonymous
Please see below.
Result and freq are measures I made.
Name is column in table.
Impact =
CALCULATE
([Result],ALLSELECTED(Table1[Name))
-
divide((CALCULATE([Result]*[Freq],ALLSELECTED(Table1[Name]))
-
CALCULATE([Result]*[Freq])),
CALCULATE([Freq],ALLSELECTED(Table1[Name]))-[Freq])Hope this helps
Filarap