Calculate Countrows from Merged Table

[sanket_sk]

Hi All,

Hope all are doing good!!!.

I have a unique issue with Power Bi Desktop.

I have merged Tables (Table Names - Processed_Closed_Calls & Satisfaction) and pulled satisfaction ratings in the Closed Call Table.

I have applied a few measures in the Closed Call table which are working fine however when I applying the measure on the Merged column ( Satisfaction) Power Bi is not returning the correct count, I believe it is showing all the row count, could you please help to resolve the mystery?

Formula I applied
Satisfaction = CALCULATE(COUNTROWS(Processed_Closed_Calls),Processed_Closed_Calls,Processed_Closed_Calls[Satisfaction]="Passive")

Please help to correct the formula.

Thanks
Sanket