Forum Discussion

BillyT_350's avatar
BillyT_350
Icon for Helper V rankHelper V
8 years ago

get Pie Chart to Filter Table

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 a...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi jengwt,

 

Modify your DAX formula like this and try again:

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

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

Regards,

Jimmy Tao

BillyT_350's avatar
BillyT_350
Icon for Helper V rankHelper V
8 years ago

Sorry, v-yuta-msft but not only does that not solve the problem, it basically does the exact same thing as my code.