Pie chart filter

[tyan]

Name	MAJOR	BACKGROUND	STATUS	GENDER
NICK	ENGLISH	TRADING	STUDENT	F
JACK	ENGLISH	TRADING	STUDENT	M
JONHNSON	ENGLISH	TRADING	TEACH	M
ADA	ENGINEERING	MARKETING	TEACH	M
MIA	LOGISTIC	SUPPLY CHAIN	TEACH	M
ELA	INTERNATIONAL ECONOMICS AND TRADING	MARKETING	TEACH	M
ZERO	LOGISTIC	SUPPLY CHAIN	STUDENT	M
FISHHING	MATH	MARKETING	STUDENT	M
LULU	MATH	MARKETING	TEACH	F
LALO	ENGINEERING	MARKETING	TEACH	c

I got this table as my database. I would like to create two pie charts that display two team: count of teach team by gender and count of student team by gender. 

This chart looks good but once I click on it, the other pie chart other gender turn into 0. As you can see, I select Student Team M and Teach Team F is 0. 

I used this two dax functions, Please correct me. 

COUNT OF STUDENT = CALCULATE(COUNT(Sheet1[GENDER]),Sheet1[STATUS]="STUDENT")

COUNT OF TEACH = CALCULATE(COUNT(Sheet1[GENDER]),Sheet1[STATUS]="TEACH")

[amitchandak]

@tyan , Try like

COUNT OF STUDENT = CALCULATE(COUNT(Sheet1[GENDER]),filter(Sheet1, Sheet1[STATUS]="STUDENT"))

COUNT OF TEACH = CALCULATE(COUNT(Sheet1[GENDER]),filter(Sheet1,Sheet1[STATUS]="TEACH"))

[tyan]

@amitchandak I still get what i had. 

the other one is zero once I selected on the chart 

[v-easonf-msft · Accepted solution]

Hi, @tyan 

I think you may need to disable the interaction between the two reports.

Please check my sample file for more details.

Related thread：

Change how visuals interact in a Power BI report 

Edit Visual Interaction Power BI 

Best Regards,
Community Support Team _ Eason