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 ,

 

Are the measure1 and measure2 the counts of selected rows and selected columns?

 

Best Regards,

Jay

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

    Anonymous  Hi Jay,

     

    Thank you for the response, you may ignore the measures, I would like get the sum of each color like below or in any format would 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.