After doing the course ’ Fixing errors with your totals efficiently’ from the ’ Mastering DAX Calculations’ course, I am trying to apply this pattern for my churn % overtime. However, when i try to do it with cumulative measures I can’t get it to work: the context of the cumulative patterns within the virtual table is not working, so either the cumulatives are only showing values for a specific month, or when i use “all(dates)” it will just show the maximum for all months.
The current formula for my churn % is:
Churnrate MRR = CALCULATE(([Cumulative Lost MRR]-[Cumulative Lost MRR LM])/[Cumulative Won MRR LM])
How I tried to apply the pattern:
Churnrate MRR new =
var churnrate = CALCULATE(([Cumulative Lost MRR]-[Cumulative Lost MRR LM])/[Cumulative Won MRR LM])
Is there a course on how to fix the totals for churn with churn rate/cumulative totals?