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 attache...
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 :)

     

     

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 :)

 

 

  • Silver75's avatar
    Silver75
    Frequent Visitor
    9 years ago

    Thank you OwenAuger

    it's perfect :smileyhappy: