Forum Discussion
Using parameters to edit two different values of a single line and be able to view new grand total
Hi zanderson45,
Based on our understanding of the issue, a possible approach is to use a disconnected Worker selector, apply the What-If parameters conditionally using SELECTEDVALUE(), and manage totals using ISINSCOPE() with SUMX() to reconstruct the full total. This ensures that only the selected worker changes while all other rows remain visible and the grand total remains accurate.
Please find attached the screenshots and a sample PBIX file for reference:
We hope that the information provided will assist in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.Thank you.
Community SupportThankyou, amitchandak and danextian , for your responses.
Hi zanderson45,
Thank you for the update.
Based on my understanding, the issue arises because selecting an employee applies a filter to the entire Employee table. When this occurs, Power BI recalculates totals only for the selected row. To maintain the grand total while modifying only one employee, we must explicitly remove that filter context within the measure.
Please find attached a screenshot and a sample PBIX file for reference:
We hope the information provided will assist in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
Hello v-pnaroju-msft ,
Company policy will not allow me to download the example file, is there a way you are able to screenshot other parts of the file?
In the screenshot you provided it is like the second screenshot that I provided where I am able to edit an individuals percent and months but that change is not compared to the other employees i.e. in your example the other employees’ figures are not visible to see the impact of the change to Alice’s months and percentage. I attached another screenshot that I edited to show what the goal of the dashboard is. The yellow box shows only c had their distribution percentage and months remaining adjusted while a and b remained the same.