switch selected value not showing value

Question

hello i have this formula:&nbsp;&nbsp;VB Financial Value = SWITCH( &nbsp; &nbsp; SELECTEDVALUE(Sheet1[Line Description item id]),&nbsp; &nbsp; "Salesperson" , [Salesperson],&nbsp; &nbsp; "Accountant" , [Accountant],&nbsp; &nbsp; "HR Cost" , [HR Cost],&nbsp; &nbsp; "Attorney Fees",[Attorney Fees],&nbsp; &nbsp; "Carrier 1",[Carrier1],&nbsp; &nbsp; "Carrier 2",[Carrier 2],&nbsp; &nbsp; "Carrier 3",[Carrier 3],&nbsp; &nbsp; "Carrier 4",[Carrier 4],&nbsp; &nbsp; "Fees",[Fees],&nbsp; &nbsp; "Carrier 5",[Carrier 5],&nbsp; &nbsp; "Carrier 6",[Carrier 6],&nbsp; &nbsp; "Total Expenses",[ total Expenses],&nbsp; &nbsp; "Total Minutes",[Minute Cost],&nbsp; &nbsp; "Net Profit",'[Net profit],&nbsp; &nbsp; "Total Expenses",[total Expenses],&nbsp; &nbsp; "Payroll Expenses",[Payroll Expenses])&nbsp;and i got the result here:&nbsp;ExpenseAmountPayroll Expenses&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Salesperson8000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Accountant12908.45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HR Cost26250Business Expenses&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Attorney Fees11250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fees88546.5Minutes Expenses&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Carrier 124250.61&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Carrier 2116146.87&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Carrier 3409727.58&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Carrier 4256689.8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Carrier 52660.65&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Carrier 618457.64Total Minutes&nbsp;Taxes&nbsp;Total Expenses&nbsp;Net Profit&nbsp;&nbsp;as you can see i have missing value not showing&nbsp;when i put the results in cards, they are shown and correct but in the table they dont show please help&nbsp;NB: payroll expenses is : [salesperson] + [accountant] + [HR Cost]&nbsp; &nbsp; &nbsp; business Expenses is : [fees] + [attorney fees] ...&nbsp;so i noticed tha all subsets are being shown the one i used calculate(sum()) formula to get the amount but when i used measures to add totals it doesnt show please help

amitchandak · Answer

Anonymous .The measure need to changed like 
&nbsp;
calculate([salesperson] + [accountant] + [HR Cost], all(Sheet1[Line Description item id])) 
&nbsp;
or
&nbsp;
calculate([salesperson] + [accountant] + [HR Cost], allselected(Sheet1[Line Description item id]))

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
You can refer the following links to try to solve your problem...
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Dax for Power BI: Fixing Incorrect Measure Totals
&nbsp;
If the above one can't help you get the desired result, please provide some&nbsp;sample data&nbsp;in the table "Sheet1" (exclude&nbsp;sensitive&nbsp;data) with&nbsp;Text&nbsp;format, the Fields setting of your matrix visual and the formula of involved measures.&nbsp;It is better&nbsp;if you can share a&nbsp;simplified&nbsp;pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community

Best Regards

anonymous · Answer

Hi&nbsp;&nbsp;Anonymous&nbsp;,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards

Forum Discussion

switch selected value not showing value

3 Replies

Related content

Alternative to SWITCH ()?

Switch Time Zone on DateTime Columns based on User Selection

Switch -Containsstring

Show only selected Company value

Switch measure value with 2 selection

Expense	Amount
Payroll Expenses
Salesperson	8000
Accountant	12908.45
HR Cost	26250
Business Expenses
Attorney Fees	11250
Fees	88546.5
Minutes Expenses
Carrier 1	24250.61
Carrier 2	116146.87
Carrier 3	409727.58
Carrier 4	256689.8
Carrier 5	2660.65
Carrier 6	18457.64
Total Minutes
Taxes
Total Expenses
Net Profit