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