Bar chart filtering specific records

[pakovic]

Good afternoon and thank you in advance for your help. I have a table with business opportunities, with the fields ID, status, and date. I would like a bar chart in which, upon selecting a date, the data for "ganados" and "perdidos" opportunities would be recalculated, but the pending ones would be shown regardless of the date selection made in the filter. Is there any solution?  In the example I am attaching, the "Pendientes" always have to show 9 regardless of the filters applied.

I am attaching the PBIX file.

https://www.dropbox.com/s/8he19aybtxm105s/oportunidad.pbix?dl=0

[Ritaf1983]

Hi @pakovic 
Please try this formula :

Contar = if(max('oportunidades'[estado])<>"pendiente",

 COUNT(oportunidades[id]),

  CALCULATE(COUNT('oportunidades'[id]),all('Calendar')))

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[pakovic]

But if I select April, I don't see the Pendiente. Is there any way to show me the 3 bars, maybe showing the accumulated? how could I put the formula?