I'm new to PowerBi and I want to have the following:
I want to create a slicer which allows me to transfer 'capacity' from one entity to another. I.e. If the entity A has 300 capacity and entity B and C -20, I would like to create a slicer so I can transfer for example 20 capacity to entity B and 20 capacity to entity C.
I tried a what if parameter but without any success.
Thank you in advance for any help!
Is this your expected final output?
If so, please refer to this measure.
Measure = IF ( SUM ( Table3[Capacity] ) < 0, 0, CALCULATE ( SUM ( Table3[Capacity] ), ALLSELECTED ( Table3 ) ) )
Thanks for the help! It is the expected final output in this case, but in other cases not.
I want to create a dashboard where my client can see his different entities with their capacity. Further, I want to provide a sort of slicer where he can interactively transfer excess capacity to another entity.
I.e. A has excess capacity of 300 and B is negative 100 so we take from entity A -100 and add to entity B +100. Entity C remains unchanged.
It could be that for another client entity C has 1000 capacity and entity A -200, so the same slicer which allows him to transfer -200 from C to add 200 to A.
Hope this clarifies what I need.
Help is very appreciated!
Hi @tomprg ,
Is the slicer used to specify the number to transfer? And Is it always transferring from positive entity to negative entity? Or the transfer regulation varies based on report viewer's selection?