How do I count rows from related Tables using DAX

0 votes
Hi Everyone,

I hope you're doing well !!!

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")

Thanks & Regards,

Sanket
Sep 14, 2021 in Power BI by SANKET

edited Mar 4 21 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP