Parent Child relation ship for dashboarding

Hi k_rahul_g ,

I think I understand your requirements and I'm assuming that the only field that will cause duplicates as described is [CR].

Based on this assumption, the following new measures for [effort budgeted] and [effort actual] should work:

_effortBudgetSplit =
VAR __crCount =
CALCULATE(
  DISTINCTCOUNT(yourTable[CR]),
  ALLEXCEPT(yourTable, yourTable[Work CR])
)
RETURN
SUM(yourTable[effort budgeted]) / __crCount

_effortActualSplit =
VAR __crCount =
CALCULATE(
  DISTINCTCOUNT(yourTable[CR]),
  ALLEXCEPT(yourTable, yourTable[Work CR])
)
RETURN
SUM(yourTable[effort actual]) / __crCount

Obviously, I don't know if your screenshot shows columns or measures, or what your model/table structure is, but hopefully the above measures give you an idea of how to handle your scenario.

Pete