Forum Discussion

VT_KMS's avatar
VT_KMS
New Member
1 year ago

Issue with Aggregating Measures Using SELECTEDVALUE()

Hi all, I am having an issue with using SELECTEDVALUE(). I created a measure with SELECTEDVALUE() to calculate revenue change at the product level. However, when I try to aggregate that value to th...
sjoerdvn's avatar
sjoerdvn
Solution Sage
1 year ago

You could try something like below.

revenue_change_product =
CALCULATE(SUM(ARRDATA_CUSTOMER_PRODUCT[ARR_AMOUNT]) - [PRE_CROSS-SELL1], KEEPFILTERS(ARRDATA_CUSTOMER_PRODUCT[CATEGORY_PRODUCT] = "CROSS-SELLPRODUCT1")
+ CALCULATE(SUM(ARRDATA_CUSTOMER_PRODUCT[ARR_AMOUNT]) - [PRE_LOST_PRODUCT1], KEEPFILTERS(ARRDATA_CUSTOMER_PRODUCT[CATEGORY_PRODUCT] = "LOST-PRODUCTPRODUCT1")
+ CALCULATE(SUM(ARRDATA_CUSTOMER_PRODUCT[ARR_AMOUNT]) - [PRE_REACT_PRODUCT1], KEEPFILTERS(ARRDATA_CUSTOMER_PRODUCT[CATEGORY_PRODUCT] = "PRODUCT REACTIVATIONPRODUCT1")