Forum Discussion

Sudhavi_84's avatar
Sudhavi_84
Helper V
5 years ago
Solved

Sum based on Child level

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

 

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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

2 Replies