Earn 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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |