Having trouble with slicer filtering measure incorrectly

[mo-aisha]

Hi,

I am having trouble getting the values I expect for my measures in a matrix when I apply filtering with a slicer.

Problem Details

When the churn label on the filter is set to ‘No’, a positive churn rate is still reported in the matrix. I expect the churn rate to be 0% for the churn rate measure in the matrix, not positive. It works the other way around i.e. when the churn label on the slicer is ‘Yes’ the churn rate measure is 100%. See the screenshots below.

Background / Context

I am using the Telco Consumer Dataset here https://github.com/Pranjali-D/Telco_Customer_Churn_Analysis/tree/main/Data%20Source , and the data model is below.

I have a matrix where I am visualising the churn rate measure calculated using the DAX formulas below, for each contract type (from the services table): 

Churn Rate = DIVIDE([Number of Churned Customers], [Number of Customers]) . 

Number of Churned Customers = CALCULATE([Number of Customers],'Customer Status'[Churn Label] = "Yes")

Number of Customers = COUNT('Customer Status'[Customer ID])

I also have a slicer on the page that filters the matrix based on the churn label from the Customer Status table.

Please advise. Thank you.

[Selva-Salimi]

Hi @mo-aisha 

Do you have unique values of churn status for each customer in customer status table?! I think it might changed over a period. and did you want to count number of customers that have at least one churn?

[mo-aisha]

Hi @Selva-Salimi ,

Thank you for your message.

Yes, each customer has a unique value for churn status in the table. Each row in the table represents a unique customer.

Yes, I want to be able to filter on the churn label so that the churn rate measure is calculated for each row in the matrix based on the slicer selection.  For example, if I select churn label = No on the slicer, I expect the churn rate for each row in the matrix to be 0% not positive.