cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Need Help: How to set Measure in mother & child table

Dear All

 

Find below Mother Table format & have create child table as per below 

 

Mother Table

MONTHAGENCYCHG_CODEVDA AMOUNTBKG_NUMCON_NUMVDA NUM
November-18SHAL-CCUWASH9.75SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUSUR9.75SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUSOR0SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCULAS0.05SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUISPS3.25SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUICOM-10SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUFRT300SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUEQP26SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUECRS150SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUDTHC117SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUDMG9.27SHLPK18001152AMFU3221483AGIN1819000129HQ

 

Child Table: 1

VDASUM = SUMMARIZE(VDA, VDA[AID_BKG_ID], VDA[AID_BKG_NUM], VDA[AID_CON_NUM],VDA[EXPECT2], "VDA AMOUNT", SUM(VDA[AID_F_AMT]))
 
Child Table: 2
 VDASUM1 = CALCULATETABLE('VDASUM', VDASUM[AID_CON_NUM] <> BLANK())
 
Filters are apply as per mother table data & Meaure will set based by Child Table 2
 
Kindly advise how to set the Measure in Mother table while reture the value from Child table 2
1 REPLY 1
Super User II
Super User II


I do not understand your question and your goal.
Do you still need help?
Can you provide a sample PBIX file?
 
Please give Kudos for support.
If I answered your question, please mark my post as solution, this will also help others.
Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors