Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create a measure using relations and performing a multiplication

Having three tables, i need to come up with a measure that does a multiplication using values from those three tables, however making use of the existing relationships.   Article Id Name Valu...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure how your datamodel looks like, but I assume the relationship looks like below.

    Please check the below picture and the attached pbix file.

     

     

     

     

     

    Expected result measure: =
SUMX (
    Article,
    Article[Value]
        * SUMX ( RELATEDTABLE ( ArticleDetail1 ), ArticleDetail1[Value2] )
        * SUMX ( RELATEDTABLE ( ArticleDetail2 ), ArticleDetail2[Value3] )
)

     

AndresOH's avatar
AndresOH
Frequent Visitor
3 years ago

Hello, how would you do this measure if you need to add an if condiction? For example, only multiply if Article Id > 2.