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

 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?  

    • akwang's avatar
      akwang
      Advocate II
      8 years ago

      the same formula you told me to use.

      • SivaMani's avatar
        SivaMani
        Resident Rockstar
        8 years ago

        akwang,

        How did you calculate Line Prod and Total line Prod?

         

        Where it comes from?

         

        could please share some sample data? pbix file would be great