Forum Discussion

vin26's avatar
vin26
Icon for Resolver I rankResolver I
6 years ago

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

Hello,   I have created a matrix by using below link: https://community.powerbi.com/t5/Developer/Apply-Colors-to-selected-range-in-matrix/m-p/1074834    Now, my requirement is to create a summar...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.