Forum Discussion

gregers1972's avatar
gregers1972
Frequent Visitor
4 years ago
Solved

DAX calculation for factor correction

Good Morning I have a small issue with some data, where they need to be rescaled as follows. Lets say we have a pressure value p_i (i = 1 - n) and I need to scaled this as : p_i_scaled = (p_i / 3276...
  • tamerj1's avatar
    tamerj1
    4 years ago

    gregers1972 

    You can 

    SUMX ( 'Table', 500 * 'Table'[VarValue] / 32768 )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi gregers1972 
I was talking about the expected results. Please illustrate with an example calculation

gregers1972's avatar
gregers1972
Frequent Visitor
4 years ago

For the first row with p_i = 345.3 the calculation is:

p_i_corrected = (345.3 / 32768) * 500 = 5.27

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    gregers1972 

    Not sure if I correctly understand but you may create a new calculated column 

    500 * 'Table'[VarValue] / 32768

    • gregers1972's avatar
      gregers1972
      Frequent Visitor
      4 years ago

      Thanks and thought the actual calculation would be like this. The trick is that there are several values in multiple rows for the same parameter e.g. A for different timepoints, which must be selected and corrected individually.

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        4 years ago

        gregers1972 
        I'm still trying to guess. Please provide the full picture so that I can understand the requirement. How many tables are invloved in this? What are the relationships?