Forum Discussion

akwang's avatar
akwang
Icon for Advocate II rankAdvocate II
8 years ago
Solved

Line Efficiency DAX formula

Hi I need help with a formula below:   This is what i want     Total KG/h Actual Total KG/h Standard Production Efficiency % Line 1 240 250 96% Line 2 273 300 91% Line 3 116...
Need Help
  • akwang's avatar
    akwang
    8 years ago

    Hi SiviMani,

     

    I fixed the problem by enabling relationships as both direction relationship.

akwang's avatar
akwang
Icon for Advocate II rankAdvocate II
8 years ago

Hi Ihave the data in two separate tables. One with the actual prod and the other with the Standard for Line 1,2,3.

 

How would i calculate that?

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
8 years ago

 akwang,

 

Sorry, I thought you have the values in the same table

 

Create a relationship between the tables based on the Line.

 

Then create a calculated measure,

Production Efficiency % = DIVIDE(SUM(Table1[Total KG/h Actual]),SUM(Table2[Total KG/h Standard]),0)

  • akwang's avatar
    akwang
    Icon for Advocate II rankAdvocate II
    8 years ago

    Hi This is what i get on the table visual and my reference table is below:

     

    TABLE VISUALREF TABLE

    The STD is not sepatating by line causing incorrect %efficiency

    • SivaMani's avatar
      SivaMani
      Icon for Resident Rockstar rankResident Rockstar
      8 years ago

      What was the procedure you followed to get that output?  

      • akwang's avatar
        akwang
        Icon for Advocate II rankAdvocate II
        8 years ago

        the same formula you told me to use.