Forum Discussion

akwang's avatar
akwang
Advocate 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
Resident 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
Advocate 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
    Resident 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
      Advocate 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
        Resident Rockstar
        8 years ago

        What was the procedure you followed to get that output?