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.

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

  • akwang's avatar
    akwang
    Advocate II
    8 years ago

    Hi SiviMani,

     

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