Forum Discussion

Silver75's avatar
Silver75
Frequent Visitor
9 years ago
Solved

How calculate a particular interaction between two measures

Hi

I have to calculate a particular interaction between 2 measure. It's a product, but I don't know it

target= Measure2, where

 

Measure 2 = Measure1* Measure2 at level -1

 

please find attached an example in Excel

thanks

 

Need Help
Show and Tell
Tips and Tricks
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    Silver75

     

    I'm assuming 'scalar' is a column and Measure1 is a measure.

    It looks like you want Measure2 to return the cumulative product of Measure1 over the 'scalar' column.

     

    You could define Measure2 like this for example:

    Measure2 =
PRODUCTX (
    FILTER (
        ALL ( YourTable[scalar] ),
        YourTable[scalar] <= MAX ( YourTable[scalar] )
    ),
    [Measure1]
)

    Owen :)

     

     

2 Replies

  • OwenAuger's avatar
    OwenAuger
    Super User
    9 years ago

    Silver75

     

    I'm assuming 'scalar' is a column and Measure1 is a measure.

    It looks like you want Measure2 to return the cumulative product of Measure1 over the 'scalar' column.

     

    You could define Measure2 like this for example:

    Measure2 =
PRODUCTX (
    FILTER (
        ALL ( YourTable[scalar] ),
        YourTable[scalar] <= MAX ( YourTable[scalar] )
    ),
    [Measure1]
)

    Owen :)