Challenge with measure not correctly applying filters from visual - Why!??

[Anonymous]

Cant get my head around why this doesnt work but here goes:

I have a table "Customers" with the following columns:

Company

Customer

Churn period

Final MRR

Churn period is the month in which the customer churned

Final MRR is the MRR at the point they churned

I have a measure MRR_Churned_In_Period =

CALCULATE( SUM( Customers[FinalMRR]), Customer[Churn period] >= MIN (DateTable[EoM], Customers[Churn period]<= MAX (DateTable[EoM])

When i apply this to a matrix table visual with DateTable[EoM] down the left (31/01/24, 28/02/24 and so on) and Companies across the top (Company A, Company B and so on) the output is the sum of all Final MRR across all companies for that month. How do i fix it so it only includes churn from the relevant company

For example, if Company A churns in Dec-24 with total final MRR (for all customers of company A that churned that month) of 100 and Company B churns in Dec-24 with total final MRR of 200 the table should be as follows:

Date        A     B

Dec-24   100   200

Instead I get

Date        A     B

Dec-24   300   300

Whats going on?

[Anonymous · Accepted solution]

Hi @Anonymous ,

From the information you provided, your current matrix does not classify the results by company. I suggest you check whether the company column in your matrix comes from the customer table. If it comes from a separate company table, please make sure there is a relationship between the company table and the customer table, such as

company [company] - customer[company]: One to Many.

If the above method do not solve the problem, it is best to provide sample data, screenshots and pbix files (excluding private data).

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

Best regards,

Mengmeng Li

[bhanu_gautam]

@Anonymous , Try using

MRR_Churned_In_Period =
CALCULATE(
SUM(Customers[Final MRR]),
Customers[Churn period] >= MIN(DateTable[EoM]),
Customers[Churn period] <= MAX(DateTable[EoM]),
Customers[Company] = SELECTEDVALUE(Customers[Company])
)

[Anonymous]

With that change i just get a completely blank table with no data....