Pie chart with Measure - not filtering the corresponding table

[umeshbanga]

Hi

Scenario

I have a pie chart that was created using Measures. 

Measures are calculating the total number of advisers with licensee.

Ask

I want a table that will interact with this pie chart and display the results relevant to the specific pie of the chart. For example, if a pie slice value is 2, then table should automatically filter out and show only 2 corresponding values.

Any suggestions?

[Anonymous · Accepted solution]

Hi  @umeshbanga ,

I created some data:

Here are the steps you can follow：

1. Create measure.

the total number of advisers with licensee =
COUNTX(FILTER(ALL('Table'),'Table'[licensee]=MAX('Table'[licensee])),[advisers])

2. In the table visual it is .

3. Pie Visual is.

4. Result:

Click on Pie Visual to filter the table Visual

If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.

Best Regards,

Liu Yang

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

[umeshbanga]

@Jihwan_Kim tagging you as you helped me with giving a solution for the measures.