Calculation using 2 measures gives in correct total in Table

[jesly_ajin]

Hi dears,

I have 2 measures namely - 

1. ECPlanCount is SUMX(FILTER(SelfService_Plan_DailyPlanHour, SelfService_Plan_DailyPlanHour[RANKPlan]=1), SelfService_Plan_DailyPlanHour[ECPlannedCount])

2. ECPlanCost is SUMX(FILTER(SelfService_Plan_DailyPlanHour, SelfService_Plan_DailyPlanHour[RANKPlan]=1), SelfService_Plan_DailyPlanHour[ECPlannedCost])

3. I have another measure that uses these measures

DActualCost = [ECPlanCount]*10*[ECPlanCost]

When these are put in matrix or table, the sum of ECPlanCount & ECPlanCost, however, the total os DActualCost is incorrect.

Kindly help.

[v-stephen-msft · Accepted solution]

Hi @jesly_ajin ,

I created a sample pbix with your measure.

You can use new measure like

DActualCost = SUMX(FILTER(SelfService_Plan_DailyPlanHour, SelfService_Plan_DailyPlanHour[RANKPlan]=1),[ECPlanCount]*10*[ECPlanCost])

Or

AnotherDActualCost = CALCULATE([ECPlanCount]*10*[ECPlanCost],ALL('SelfService_Plan_DailyPlanHour'))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@jesly_ajin , Multiplication should be done at line level, Try like

DActualCost =

SUMX(FILTER(SelfService_Plan_DailyPlanHour, SelfService_Plan_DailyPlanHour[RANKPlan]=1), SelfService_Plan_DailyPlanHour[ECPlannedCount]*SelfService_Plan_DailyPlanHour[ECPlannedCost])

[jesly_ajin]

@amitchandak I tried but it is giving blank values.

[amitchandak]

@jesly_ajin there was *10 too, try

SUMX(FILTER(SelfService_Plan_DailyPlanHour, SelfService_Plan_DailyPlanHour[RANKPlan]=1), SelfService_Plan_DailyPlanHour[ECPlannedCount]*SelfService_Plan_DailyPlanHour[ECPlannedCost]*10)

or

SUMX(FILTER(SelfService_Plan_DailyPlanHour, SelfService_Plan_DailyPlanHour[RANKPlan]=1), SelfService_Plan_DailyPlanHour[ECPlannedCount]*SelfService_Plan_DailyPlanHour[ECPlannedCost])*10

if not

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.