Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 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.

dhaval1001shah's avatar
dhaval1001shah
Regular Visitor
4 years ago

Dear Mr. Ashish,

 

Thank yoi for your reply.

 

However, i am not able to get % when i select ABC from my store ID list. Over all it gets tally when i divide total discount with total sales.

 

However when i select store ID ABC then i must get 20% (ABC dis amt is 10 and Sales is 50 = 20%). But i am not getting the same.

 

Kindly help.

 

I followed all steps which you given above.

 

Thank You.

Regards

CA Dhaval Shah

 

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

Hi,

Share the link from where i can download your PBI file and show the problem very clearly.