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

[kalif]

Dear All

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

Mother Table

MONTH	AGENCY	CHG_CODE	VDA AMOUNT	BKG_NUM	CON_NUM	VDA NUM
November-18	SHAL-CCU	WASH	9.75	SHLPK18001152	AMFU3221483	AGIN1819000129HQ
November-18	SHAL-CCU	SUR	9.75	SHLPK18001152	AMFU3221483	AGIN1819000129HQ
November-18	SHAL-CCU	SOR	0	SHLPK18001152	AMFU3221483	AGIN1819000129HQ
November-18	SHAL-CCU	LAS	0.05	SHLPK18001152	AMFU3221483	AGIN1819000129HQ
November-18	SHAL-CCU	ISPS	3.25	SHLPK18001152	AMFU3221483	AGIN1819000129HQ
November-18	SHAL-CCU	ICOM	-10	SHLPK18001152	AMFU3221483	AGIN1819000129HQ
November-18	SHAL-CCU	FRT	300	SHLPK18001152	AMFU3221483	AGIN1819000129HQ
November-18	SHAL-CCU	EQP	26	SHLPK18001152	AMFU3221483	AGIN1819000129HQ
November-18	SHAL-CCU	ECRS	150	SHLPK18001152	AMFU3221483	AGIN1819000129HQ
November-18	SHAL-CCU	DTHC	117	SHLPK18001152	AMFU3221483	AGIN1819000129HQ
November-18	SHAL-CCU	DMG	9.27	SHLPK18001152	AMFU3221483	AGIN1819000129HQ

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

[mwegener]

Hi @kalif ,

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.