Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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".
Go to Solution.
=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]))
View solution in original post
thank you @tamerj1 . It worked !!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.