Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
pg1981
New Member

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

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?

1 ACCEPTED SOLUTION
v-mengmli-msft
Community Support
Community Support

Hi @pg1981 ,

 

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

View solution in original post

3 REPLIES 3
v-mengmli-msft
Community Support
Community Support

Hi @pg1981 ,

 

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
Super User
Super User

@pg1981 , 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])
)




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.