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.

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
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.