Forum Discussion
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...
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.
Ashish_Mathur
Super User
Super UserHi,
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.
Thx it works perfectly!:smileyhappy:
- Ashish_Mathur
You are welcome.
Dear Mr. Ashish,
I need solution for given below:
Thank You.
Table 1
Table 2 Requirement Store ID Dis Amt Store ID Sales Store ID Dis % To Sales ABC 2 ABC 50 ABC 20%
ABC 4 BCD 2 ABC 4 BCD 6 DEF 4 DEF 2
