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.

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

Hi akwang,

 

Create a calculated column with Divide function.

 

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

 

 

Then Change the Format to Percentage which under modeling tab

 

regards,

Siva

 

 

  • 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