Forum Discussion

KS_India's avatar
KS_India
Frequent Visitor
2 years ago
Solved

How to retrieve value from Incentive Measure by using if condition

Hi Team, I am introducing new incentive value through measure. I need to give the same incentive only on hardware so by introducing new column I put a if condition that " Revised Sales = if('...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi KS_India 

     

    Based on your description, my understanding is that you seem to have two tables and have created a calculated column that uses fields from both tables in that formula. As per my judgment, your screenshot shows the data from the "Table" table, can you show the data from the other table so that I can help you better. Please remove any sensitive data in advance.


    For now, my suggestion is that you try the following formula:

     

    Revised Sales = if('Table'[Commodity] = "Hardware", 'Table'[Incentive], BLANK())

     

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi KS_India 

 

Based on your description, my understanding is that you seem to have two tables and have created a calculated column that uses fields from both tables in that formula. As per my judgment, your screenshot shows the data from the "Table" table, can you show the data from the other table so that I can help you better. Please remove any sensitive data in advance.


For now, my suggestion is that you try the following formula:

 

Revised Sales = if('Table'[Commodity] = "Hardware", 'Table'[Incentive], BLANK())

 

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.