Forum Discussion

smartpug's avatar
smartpug
New Member
3 years ago
Solved

Calculating values based on two tables

Hi all, I am a super beginner and have the following case: Problem:  We have two tables: Products and Orders. They have a One-To-Many relationship so one Product might be in a few orders - a c...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    maybe you want a measure, instead of calculated column

    NewMeasure=SUMX(Products,COUNTROWS(RELATEDTABLE(orders))*Products[Price])

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

if you are adding calculated column in Products table, try this code

NewColumn=COUNTROWS(RELATEDTABLE(Orders))*Products[Price]