Forum Discussion

sfink22's avatar
sfink22
Helper I
5 years ago
Solved

Multiplying across tables

I'm trying to create some matrix visuals in my dashboard for some product manufacturing information.    I have three tables that are related in my model by my primary key, Recipe. The Recipe table ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, sfink22 

    Sorry that I missed to fix the total.

    Please replace the measure to the below.

     

    Result =
    SUMX (
    VALUES ( Recipe[Recipe] ),
    CALCULATE (
    SUMX ( Component, Component[% Mix] ) * SUMX ( Volume, Volume[Volume] )
    )
    )

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, sfink22 

Sorry that I missed to fix the total.

Please replace the measure to the below.

 

Result =
SUMX (
VALUES ( Recipe[Recipe] ),
CALCULATE (
SUMX ( Component, Component[% Mix] ) * SUMX ( Volume, Volume[Volume] )
)
)

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

sfink22's avatar
sfink22
Helper I
5 years ago

Thank you, this worked perfectly!