topic Challenge with measure not correctly applying filters from visual - Why!?? in DAX Commands and Tips

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

Anonymous — Mon, 03 Feb 2025 11:51:54 GMT

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?

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

bhanu_gautam — Mon, 03 Feb 2025 12:15:32 GMT

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

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

Anonymous — Mon, 03 Feb 2025 12:41:46 GMT

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

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

Anonymous — Tue, 04 Feb 2025 07:37:34 GMT

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