Forum Discussion
rajasekar_o
Helper V
Helper Vhow 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
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.