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 SupportHi 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.
Thank you v-pnaroju-msft, after some tinkering I was able to get it to work. Really appricate your time and help with this project.