Forum Discussion
Creating a measure that includes a lookup
Hello, I am trying to create a measure that multiplies the total amount invested (plush a cash balance) by a % limit based on another table. The first image is the measure I've created that sho...
I figured it out.
The following code was what I needed:
Available to invest = (CALCULATE(SUM(Data[Amount]),ALL(Data[Issuer]))+'Cash Balance'[Cash Balance Value])*LOOKUPVALUE ( 'Approved Names'[Limit], 'Approved Names'[Issuer], 'Measures List'[Selected Issuer])thank you
I figured it out.
The following code was what I needed:
Available to invest = (CALCULATE(SUM(Data[Amount]),ALL(Data[Issuer]))
+'Cash Balance'[Cash Balance Value])
*LOOKUPVALUE ( 'Approved Names'[Limit], 'Approved Names'[Issuer], 'Measures List'[Selected Issuer])
thank you