Forum Discussion

jesly_ajin's avatar
jesly_ajin
Icon for Helper III rankHelper III
5 years ago
Solved

Calculation 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])   ...
  • Anonymous's avatar
    Anonymous
    5 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.