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 ActualTotal KG/h StandardProduction Efficiency %
Line 124025096%
Line 227330091%
Line 311612097%
Line 4425084%

 

How can i create a formula that would result in the Production Efficiency % column? When i Sum the Actual it remains according to line, but when i sum the standard i get 720 as all the standard rather than as it is on the table.

Need Help
  • akwang's avatar
    akwang
    8 years ago

    Hi SiviMani,

     

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

8 Replies

  • 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)