Forum Discussion

Helper II

6 years ago

Solved

SUM ( RELATED () ) dont work

Hi all,

i have the following calculation with SUM ( RELATED () ) which dont work:

X = CALCULATE(SUM('Table1'[ABC]) / SUM(RELATED('Table2'[CDE])); ALLSELECTED('Table1'[EFG]))

i have the error massage that SUM only accepts one column reference as argument.

how can i bypass the SUM(RELATED())?

many thanks

Anonymous
Not applicable
6 years ago
powerbityro

You cannot use related or relatedtable after SUM. Simply remove RELATED will work.

The correct way of using RELATED AND RELATEDTABLE is when you restrict you context to a table and you want referent column from another related table. e.g. Revenue = TableA[QTY] * RELATED(TableB[Sales Price])

RELATED/RELATEDTABLE: https://theexcelclub.com/dax-power-pivot-power-bi-ssas-related-and-relatedtable/

Best,
Paul.
parry2k
Super User
6 years ago
powerbityro you cannot use RELATED function in SUM

you can do simple SUM on Table2[CDE] and it would work.
Greg_Deckler
Community Champion
6 years ago
See if SUMX meets your needs. Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490