Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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?
Solved! Go to Solution.
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
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
@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])
)
Proud to be a Super User! |
|
With that change i just get a completely blank table with no data....
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |