Forum Discussion

rajasekar_o's avatar
rajasekar_o
Icon for Helper V rankHelper V
2 years ago
Solved

how to uses two parameters for two items in matrix or table view

Hii team , I want to increase note price 10%  and  calculator  8%, how to use 2 parameter in one  table / matrix If I change price 10% its apply to all product  
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi rajasekar_o ,

     

    Please try measure as below.

    if amt = CALCULATE(SUM('Table'[AMT]))* (1 + SELECTEDVALUE(Parameter[Parameter])/100)
    if price = CALCULATE(SUM('Table'[UNITPRIC]))* (1 + SELECTEDVALUE(Parameter[Parameter])/100)

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    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 rajasekar_o ,

 

Please try measure as below.

if amt = CALCULATE(SUM('Table'[AMT]))* (1 + SELECTEDVALUE(Parameter[Parameter])/100)
if price = CALCULATE(SUM('Table'[UNITPRIC]))* (1 + SELECTEDVALUE(Parameter[Parameter])/100)

Result is as below.

 

Best Regards,
Rico Zhou

 

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