topic Re: how to multiply between two table after filter data in DAX Commands and Tips

how to multiply between two table after filter data

Trahman1971 — Sat, 28 Jan 2023 13:21:17 GMT

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

Re: how to multiply between two table after filter data

tamerj1 — Sat, 28 Jan 2023 14:45:25 GMT

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]
)
)

Re: how to multiply between two table after filter data

Trahman1971 — Sat, 28 Jan 2023 15:06:55 GMT

thank you tamerj1 . It worked !!