How to use result from visual

[awawaw]

Hello Profesissionals,

I'm facing a probelm. I used a table visual and a hierarchy slicer got my sumed weighted avg. And I want to see which range the result falls in. Like belowing. My thought was to reuse this 60% and build the relationship between two tables. However, I couldn't find a way.  Please help me.

Really appreciate.

[awawaw · Accepted solution]

I found the solution. I use the "Selectcolumn" function. It will return a table. 

[v-jingzhang]

Hi @awawaw 

The description of the problem is not clear enough. Can you provide some sample data and expected result to help clarify it better? 

From the screenshot I notice that the total value of [Sum of WA Points] is 60%, which is the same as the value in the card visual. However I don't know how it should be related to the second table visual below. There is no common column. Can you explain how it should affect the other table visual? 

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.