TOTAL of Cost in Matrix view not working ?

[ashmitp869]

Hi,

I am using matrix for this report

The Cost is a measure -

Cost = SWITCH(
SELECTEDVALUE(Plan_DailyPlanHoursResourceVersion[ResourceType]),
3001,CALCULATE(SUMX(Plan_DailyPlanHoursResourceVersion,Plan_DailyPlanHoursResourceVersion[ApprovedStdHours] * RELATED(Core_ProjectEquipment[UnitCost])) ),
3003,CALCULATE(SUMX(Plan_DailyPlanHoursResourceVersion,Plan_DailyPlanHoursResourceVersion[ApprovedStdHours] * RELATED(Core_ProjectEmployee[StraightTimeRate])) )
) 

The TOTAL at the Cost is not working. ? How can I make it work - to get TOTAL of Cost $ 914, 010 ?
Please suggest.

[Shravan133 · Accepted solution]

use HASONEVALUE instead of SELECTEDVALUE in your measure. Please verify ther esults after modifying the measure.

Cost =
IF(
HASONEVALUE(Plan_DailyPlanHoursResourceVersion[ResourceType]),
SWITCH(
SELECTEDVALUE(Plan_DailyPlanHoursResourceVersion[ResourceType]),
3001, SUMX(
Plan_DailyPlanHoursResourceVersion,
Plan_DailyPlanHoursResourceVersion[ApprovedStdHours] * RELATED(Core_ProjectEquipment[UnitCost])
),
3003, SUMX(
Plan_DailyPlanHoursResourceVersion,
Plan_DailyPlanHoursResourceVersion[ApprovedStdHours] * RELATED(Core_ProjectEmployee[StraightTimeRate])
)
),
-- Handling Totals:
SUMX(
Plan_DailyPlanHoursResourceVersion,
Plan_DailyPlanHoursResourceVersion[ApprovedStdHours] *
SWITCH(
TRUE(),
Plan_DailyPlanHoursResourceVersion[ResourceType] = 3001, RELATED(Core_ProjectEquipment[UnitCost]),
Plan_DailyPlanHoursResourceVersion[ResourceType] = 3003, RELATED(Core_ProjectEmployee[StraightTimeRate]),
0
)
)
)