rolling 2 months donut chart

[powerbiexpert22]

i want to show distribution of rolling 2 months promoters, detractors and passivers in donut chart but is not giving correct results. it should give 75 % for Promoters and 25 % for Passives .please see pbix file 

pbix file: 

https://drive.google.com/file/d/19JXQs2aBUTk4g6wvvCiRevSxRs3suzFr/view?usp=drive_link

Totalcustomersrolling =

CALCULATE([TotalCustomers],

DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-2,MONTH))

Promotersrolling =

CALCULATE([Promoters],

DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-2,MONTH))

Promoters = IF(

    ISBLANK(CALCULATE(COUNT(Survey[customer_id]),Survey[category]="Promoter")),0,

    CALCULATE(COUNT(Survey[customer_id]),Survey[category]="Promoter")

)

[Anonymous · Accepted solution]

Hi @powerbiexpert22 ,

Would you like the donut chart to display data from the past two months? If so, you could add a date filter to the visual and update the Values parameter to reflect a count of customer_id.

Best Regards,

Bof