Forum Discussion

RookiePBI2019's avatar
RookiePBI2019
Regular Visitor
6 years ago
Solved

Multiply measure by a factor

  Dear all,   I am completely blocked, I would need to multiply a measure calculated by a conditional factor, I mean, I have created a formula to receive an average between 2 years depending the o...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi RookiePBI2019 ,

     

    To create a measure as below.

    Measure =
VAR averag =
    AVERAGE ( 'Table'[Qty] )
VAR ty =
    MAX ( 'Table'[Order Type] )
VAR fact =
    CALCULATE ( MAX ( Factor[Factor] ), FILTER ( Factor, Factor[Order Type] = ty ) )
RETURN
    averag * fact

     

    For more details, please check the pbix as attached.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Build a relationship from the Order Type column of Table1 to the Order Type column of Table2.  In Table1, write this calculated column formula

=RELATED(Table2[Factor])

To your visual, drag Order Type from Table2.  You may now create this measure

=SUMX(Table1,Table1[Factor]*Table1[Qty])

Hope this helps.