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

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
3 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?

  • gregers1972's avatar
    gregers1972
    Frequent Visitor
    3 years ago

    It is only a single table.  In the data table shown earlier, there is an "A" row in "VarName" with multiple entries with different "timestring" and each "VarValue" (row wise) I need to correct them differently than e.g. "B"

     

    Select_VarValue = select(VarValue), from Table(VarName(A)) #Maybe need to loop over all A's

     

    Select_VarValue = 500 * 'Table'[Select_VarValue] / 32768

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

    gregers1972 

    You can 

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