Current month turnover rate (Churn)

[MatheusC]

Hello,

I found this solution to calculate the Customer Turnover Rate (Churn), in the print below a flag is created for purchases in the previous period.

The calculation to bring the Customer Turnover Rate (Churn), I am using the expression below:

Note: It's working fine, but I also want to bring the current month (current month), and this solution that I found only brings the closed months, does anyone have an idea how I can also bring the current month of the customer turnover rate?

(Count(distinct {<Ano={$(=Max(Ano))}>}[Grupo-Cliente-Venda])

-

Count(distinct{<Ano={$(=Max(Ano))},flagCompraAnterior={1}>}[Grupo-Cliente-Venda]))

/

Count(distinct{<Ano={$(=Max(Ano))}>} [Grupo-Cliente-Venda])

The result I've achieved so far:

[MatheusC]

Can anyone help me with this problem?