dax

[americahe]

Hi,

I hvae two tables: in the first one i have the order detail: one column with the order id, one with the property id an one with the price per order

in the second table i have one column with the property id and the property name

what i need is to create an extra column in the second table that sums the total cost of the orther for each property id

¿could you help with the function?

[FreemanZ]

hi @americahe 

Assuming the two tables are related, you may also try: 

TotalCostColumn =

SUMX(

   RELATEDTABLE(OrderTable),

   OrderTable[price]

)

[Greg_Deckler]

@americahe Maybe:

Column = 
  VAR __ID = [Property ID]
  VAR __Table = FILTER('First Table',[Property ID] = __ID)
  VAR __Result = SUMX(__Table, [Price Per Order])
RETURN
  __Result