Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Divide 2 different columns from different tables and linked with 2 relations

Hi All, I want to calculate the KWH per Volume -the 2 colums are in deffernt tables -The tables are linked by relationships trough intermediate tables -the expected KWH per Volume shoud be per we...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    In your visual, drag week from the Datamaster table and factory from the Factories table.  Then this measure should work

     

    =SUM(Energy[KwH])/SUM(Volume[Volume])

     

    If this does not help, then share the link from where i can download your file.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

One finding I did is that the result of the measure is different according the table where you created it.

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Please elaborate.  What problem are you facing?