Sum based on Child level

[Sudhavi_84]

Hi Experts

Let me explain in simple way my problem first:-)

I have a Master Table and Fact Table.

Master Table is related One to Many with Fact Table ID.

In Master Table I have Child Level ID's and structure is as below.

What I am trying to acheive is Sum based on Parent level but I want to display the table as Child level with Total based on "ABC" Criteria in Fact Table as below.

Please may I know how can I display based on this criteria?

I tried but sum I can show only based on Parent level.  Can anyone help how to acheive above table please as result

Thanks in Advance

[Sudhavi_84]

Thank you @amitchandak 

[amitchandak · Accepted solution]

@Sudhavi_84 , Assuming they have 1-M relation Master to fact

calculate(Sum(Fact[values]), filter(Fact, Fact[Criteria] ="ABC"))

Display this with child level of master