Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

switch selected value not showing value

hello i have this formula:    VB Financial Value = SWITCH(     SELECTEDVALUE(Sheet1[Line Description item id]),     "Salesperson" , [Salesperson],     "Accountant" , [Accountant],     "HR Cos...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous .The measure need to changed like

 

calculate([salesperson] + [accountant] + [HR Cost], all(Sheet1[Line Description item id]))

 

or

 

calculate([salesperson] + [accountant] + [HR Cost], allselected(Sheet1[Line Description item id]))