SUM ( RELATED () ) dont work

[powerbityro]

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

[V-pazhen-msft · Accepted solution]

@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.

[Greg_Deckler]

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

[parry2k]

@powerbityro you cannot use RELATED function in SUM

you can do simple SUM on Table2[CDE] and it would work.