get Pie Chart to Filter Table

Question

Hello, I've got a pie chart that , from two counting Measures, displays the number of client sites that have or have not been called in a time period. Next to it, I have a table that displays stats about the sites, including how many times they have been called in the time period.

I would like for the table to be filtered when the user clicks on a section of the pie chart, but I can't get it to work. PBI acts like it's trying to do something (screen flashes, table refreshes), but it doesn't actually filter the table.

This is a redacted example of that the page looks like:

SiteName = "Profile" (sorted by SiteID)

SiteOwner = "Owner"

Calls per Site = "Calls"

Date = "Call Date" (date slicer)

Here is the code for the two metrics that count the number of "Sites Called" and "Sites Not Called":

[measure] Calls Per Site = COUNT('Calls'[CallID])

[measure] Sites Called = CALCULATE(COUNT('Sites'[SiteID]), FILTER('Sites', [Calls Per Site] >= 1))

[measure] Sites Not Called = CALCULATE(COUNT('Sites'[SiteID]), FILTER('Sites', [Calls Per Site] < 1))

Here is some sample data of what is contained in the tables:

Sites table:

SiteID	SiteName	inits	O Mkt	D Mkt
Site1	Happy Apple Makers	1	a	c
Site2	The Most Interesting Man in the World	2	b	a
Site3	Sheep Sheerers	3	d	b
Site4	Grub's Grub Restaurant	4	b	c
Site5	Golum's Precious Finders	5	c	d

Calls:

CallID	Caller	SiteID	Date
c1	bob	Site1	4/1/2018
c2	joe	Site3	4/1/2018
c3	sally	Site2	4/1/2018
c4	ahmed	Site2	4/2/2018
c5	schmidt	Site2	4/1/2018
c6	nereese	Site1	4/1/2018
c7	juanita	Site3	4/2/2018
c8	oscar	Site2	4/2/2018
c9	ivan	Site1	4/1/2018
c10	joe	Site1	4/1/2018
c11	ahmed	Site1	4/2/2018
c12	joe	Site2	4/4/2018
c13	juanita	Site1	4/1/2018
c14	ahmed	Site3	4/2/2018
c15	oscar	Site2	4/1/2018
c16	sally	Site1	4/2/2018
c17	schmidt	Site2	4/1/2018
c18	juanita	Site1	4/2/2018
c19	oscar	Site2	4/2/2018
c20	juanita	Site1	4/1/2018

Emploees:

Employee	inits
juanita	1
joe	2
ahmed	3
schmidt	4
oscar	5
bob	6
sally	7
nereese	8
ivan	9

mfelix · Answer

Hi&nbsp;BillyT_350,&nbsp;Can you share a sample of your data? from the image is difficult to understand what is the data setup behing it.&nbsp;Thank you.&nbsp;Regards,MFelix

v-yuta-msft · Answer

Hi&nbsp;jengwt,&nbsp;Modify your DAX formula like this and try again:Sites Called =
CALCULATE (
    COUNT ( 'SitesTable'[SiteID] ),
    FILTER ( ALLSELECTED ( 'SitesTable' ), [Calls Per Site] &gt;= 1 )
)

Sites Not Called =
CALCULATE (
    COUNT ( 'SitesTable'[SiteID] ),
    FILTER ( ALLSELECTED ( 'SitesTable' ), [Calls Per Site] &lt; 1 )
)Regards,Jimmy Tao

billyt_350 · Answer

*edited OP to include this*MFelix&nbsp;Is this helpful to you? Again, I've had to make some redactions.Compared to the screenshot of the report page:SiteName = "Profile" (sorted by SiteID)SiteOwner = "Owner"Calls per Site = "Calls"Date = "Call Date" (date slicer)&nbsp;