Grouping values in a column then multiply

Hello icdns,

Please try below code :

CalculatedFinal% = 
VAR _Service= 'Table'[SERVICE]
VAR _Result=PRODUCTX(filter('Table','Table'[SERVICE]=_Service),'Table'[PERCENTAGE])
Return
_Result

Thanks! 

Hi icdns ,

1. How can I create a column to group the Apps by Service.
2. Next, after I group the the apps by service column. How will I create the FINAL PERCENTAGE column? (Formula is just 98.99% x 98.88%) 

For the two demands, you may create a calculated column like DAX below to get [FINAL PERCENTAGE], then put the column [SERVICE] , [APPNAME] ,  [PERCENTAGE] and new created column [FINAL PERCENTAGE]  into Table visual,  sort the table visual by [SERVICE], in this way, it will group the Apps by Service.

FINAL PERCENTAGE = 
VAR _Service='Table1'[SERVICE]
RETURN
PRODUCTX(FILTER('Table1','Table1'[SERVICE]=_Service),'Table1'[PERCENTAGE])

In addition, you may select on this column, go to Column Tool, set it as Percent format , and set decimal places.

Best Regards,

Amy 

Community Support Team _ Amy

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