Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kalif
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


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.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.