Summarizing the values based on the multiple slicer selections which are not conned to the table

Hi vin26 ,

I see, you want calculate the sum of value for each color based on the slicer right?

I can see we have already get color for each unit, I'm guessing if we can create a table have a column with color in rows.

Then use like sumx(martix[value],color_measure=selectedvalue(new_table[color])) to get the sum value for each color.

Can you share some sample data so that i can do some test?

Best Regards,

Jay

Community Support Team _ Jay Wang

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