Forum Discussion

zanderson45's avatar
zanderson45
Frequent Visitor
7 months ago
Solved

Using parameters to edit two different values of a single line and be able to view new grand total

I am working on a dashboard that has two parameters - a month paramter and a percentage paramter. The dashboard is designed to have the two parameters change the value of individuals encumbrance - en...
Need Help
Show and Tell
Tips and Tricks
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    7 months ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
7 months ago

zanderson45 , Try like 

Encumbrance =
VAR SelectedPerson = SELECTEDVALUE(Employee[EmployeeID])
RETURN
SUMX(Employee, Employee[Total Available]* IF( Employee[EmployeeID] = SelectedPerson, [Percentage Parameter Value], Employee[Original %])* IF(Employee[EmployeeID] = SelectedPerson, [Month Parameter Value], Employee[Original Months]))

 

 

Total Encumbrance =
SUMX(ALL(Employee), [Encumbrance])

zanderson45's avatar
zanderson45
Frequent Visitor
7 months ago

Hello amitchandak, I tried using the DAX code you provided and it gave me the same totals I previously had while trying to alter one worker's numbers still did not work. I feel as though it may be a, issue with filtering and maybe using a different table than a matrix table but I cannot figure out how to correct that.