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

I hope you mean on the data, they are as shown here for 3 series with 5 parameters and values.

VarNameTimeStringVarValue
A03/05/2022 10:00:031395
B03/05/2022 10:00:036470
C03/05/2022 10:00:0325
D03/05/2022 10:00:03216
E03/05/2022 10:00:0315815
A03/05/2022 10:00:081393
B03/05/2022 10:00:086630
C03/05/2022 10:00:080
D03/05/2022 10:00:080
E03/05/2022 10:00:0815809
A03/05/2022 10:00:131389
B03/05/2022 10:00:136730
C03/05/2022 10:00:130
D03/05/2022 10:00:130
E03/05/2022 10:00:1315806
  • 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
      Community 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