how to multiply between two table after filter data

[Trahman1971]

Hello,

I have two table which is connect as below: 

I would to filter from table(HAUL_CYCLE_GRADE_TRANS) which will show only "TLC" in column "QUALITY_CODE".

Each TLC have a value under colunm "QUALITY_VALUE". 

I would like to multiply "QUALITY VALUE" from table "HAUL_CYCLE_GRADE_TRANS" with "PAYLOAD REPORTING" from table " HAUL_CYCLE_TRANS". 

Thank you 

[Trahman1971]

thank you @tamerj1 . It worked !!

[tamerj1 · Accepted solution]

Hi @Trahman1971 

please try

=
SUMX (
HAUL_CYCLE_TRANS,
HAUL_CYCLE_TRANS[HAUL_CYCLE_TRANS]
* SUMX (
FILTER (
RELATEDTABLE ( HAUL_CYCLE_GRADE_TRANS ),
HAUL_CYCLE_GRADE_TRANS[QUALITY_CODE] = "TLC"
),
HAUL_CYCLE_GRADE_TRANS[QUALITY_VALUE]
)
)