Forum Discussion

Oros's avatar
Oros
Post Prodigy
3 years ago
Solved

If statements

Hello.   Does this issue need a conditional measure? Any idea is highly appreciated.  Thanks.   I have the following product table and customer table.   For some reasons, the price that a...
Need Help
  • Chew_WenJie's avatar
    Chew_WenJie
    3 years ago

    Hi Oros ,

    according to the sample table, I am able to get the correct table. 


    Do the same customer have different pricing level?

Chew_WenJie's avatar
Chew_WenJie
Resolver III
3 years ago

Hello, is there any relationship between the two table? if no, i think linking the pricing level between two table will solve the problem. Or, another way is create a measure 

CALCULATE(SUM('PRODUCT TABLE'[PRICE]),'CUSTOMER TABLE'[PRICING LEVEL]='PRODUCT TABLE'[PRICING LEVEL])

 

Hope able to solve the problem.

Oros's avatar
Oros
Post Prodigy
3 years ago

Hi Chew_WenJie ,

 

Thank you for your quick reply.  The customer table is related to product table through PRICING LEVEL.  Somehow, the measure that you suggested cannot find the column 'PRODUCT TABLE' [PRICING LEVEL]).  DOes the PRICING LEVEL have to be a measure and NOT a column?  Thank you again.

 

  • Chew_WenJie's avatar
    Chew_WenJie
    Resolver III
    3 years ago

    Yes, it can be a column, you may refer to the dax below.

    Pricing = CALCULATE(SUM('Product Table'[Price]),'Customer Table'[Pricing Level]=EARLIER('Product Table'[Pricing Level]))

     

    Hope this can help you.

    • Oros's avatar
      Oros
      Post Prodigy
      3 years ago

      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.

       

      • Chew_WenJie's avatar
        Chew_WenJie
        Resolver III
        3 years ago

        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