Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Please help,
I have created a "Churned" measure that is supposed to count the Running total of churned customers by days:
Thanks!
The .pbix file
https://1drv.ms/u/s!AoP_9ampPIT7yHYIkCSTho7lE-9Q?e=eQvqi0
Solved! Go to Solution.
Hi @Anonymous ,
We can try to use the following measure to meet your reqirement:
Churned =
IF (
COUNTROWS ( 'Days' ) = 0,
BLANK (),
CALCULATE (
COUNTROWS ( MyData ),
FILTER ( ALLSELECTED ( Days ), Days[Day] <= MAX ( Days[Day] ) ),
NOT ( ISBLANK ( 'MyData'[Days To Churn] ) )
)
)
If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.
Best regards,
Hi @Anonymous ,
We can try to use the following measure to meet your reqirement:
Churned =
IF (
COUNTROWS ( 'Days' ) = 0,
BLANK (),
CALCULATE (
COUNTROWS ( MyData ),
FILTER ( ALLSELECTED ( Days ), Days[Day] <= MAX ( Days[Day] ) ),
NOT ( ISBLANK ( 'MyData'[Days To Churn] ) )
)
)
If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.
Best regards,
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
66 |
User | Count |
---|---|
115 | |
107 | |
86 | |
65 | |
64 |