Forum Discussion
If statements
Hi Oros ,
according to the sample table, I am able to get the correct table.
Do the same customer have different pricing level?
Hi Chew_WenJie ,
Thank you again for your reply. Here is the actual error. Please note that Customer_Price_Group and Sales_Code are both equivalent to PRICING LEVEL in the example above. CustomerPricing table is equivalent to PRODUCT table.
Oh I see, understood. I think for the error of code above you need to change to create new column instead of measure.
Below is the code for measure and column, you may choose which you want.
Create New Measure :
Measure =
var pricinglevel = SELECTEDVALUE('Customer Table'[Pricing Level])
return
CALCULATE(SUM('Product Table'[Price]),'Product Table'[Pricing Level]=pricinglevel)Create New Column :
Pricing = CALCULATE(SUM('Product Table'[Price]),'Customer Table'[Pricing Level]=EARLIER('Product Table'[Pricing Level]))
Hope this can help you, you also can refer to the ryan_mayu solution
Hi Chew_WenJie ,
Thank you for your update.
When the (new) column is created, a customer shows 3 different pricing level instead of only 1 pricing level. The price that should show should only be $48.00.
When the (new) measure s created, the resulting table became blank.
Hi Oros ,
according to the sample table, I am able to get the correct table.
Do the same customer have different pricing level?Hi Chew_WenJie ,
May I confirm the relationship between your tables? For some reasons, the calculated column (PRICE) shows 3 pricing levels. The only correct equivalent price is $12.00 for this pricing level. Maybe I am missing something here. Thanks.