Forum Discussion

americahe's avatar
americahe
New Member
3 years ago

dax

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...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

americahe Maybe:

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