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 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.

    • SivaMani's avatar
      SivaMani
      Icon for Resident Rockstar rankResident 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

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

        Hi SiviMani,

         

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