Forum Discussion

gregers1972's avatar
gregers1972
Frequent Visitor
3 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
    3 years ago

    gregers1972 

    You can 

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

gregers1972's avatar
gregers1972
Frequent Visitor
3 years ago

The first datatable was not so easy to read but here again with 3 series and 5 parameters and values.

 

 

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

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

  • gregers1972's avatar
    gregers1972
    Frequent Visitor
    3 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
      3 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
        3 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.