Forum Discussion
Simulation Calculations?
Hi, a second question: is it possible to do kind of simulation with power bi. That I can kind of interact with a Filter of some sort, and I get a calculated table the results? ....that if i choose in a simulation row a Team, that the points go to the team and the other gets zero. So I could change the filters and can view the results and total?
| TEAM A | TEAM B | TEAM C | Total | ||
| 2 | 1 | 7 | 10 | ||
| 3 | 1 | 4 | 8 | ||
| 4 | 1 | 1 | 6 | ||
| 9 | 3 | 12 | total | ||
| FILTER | |||||
| TEAM A | TEAM B | TEAM C | Total | Simulation PRIMARY TEAM | |
| 0 | 10 | 0 | 10 | B | |
| 8 | 0 | 0 | 8 | a | |
| 0 | 0 | 6 | 6 | c | |
| 8 | 10 | 6 | total |
2 Replies
mazingazeta calculation group might solve this kind of problem.
Thank you for your response. I will try a power app, cause if I understood right, its the only way to work with Dataentry and Change the Data in realtime. Thx
