Forum Discussion
jesly_ajin
Helper III
5 years agoCalculation using 2 measures gives in correct total in Table
Hi dears, I have 2 measures namely - 1. ECPlanCount is SUMX(FILTER(SelfService_Plan_DailyPlanHour, SelfService_Plan_DailyPlanHour[RANKPlan]=1), SelfService_Plan_DailyPlanHour[ECPlannedCount]) ...
- Anonymous5 years ago
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.
Anonymous
5 years agoNot applicable
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.