Forum Discussion

pakovic's avatar
pakovic
Helper I
3 years ago

Bar chart filtering specific records

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

 

 

 

Need Help

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    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's avatar
      pakovic
      Helper I
      3 years ago

      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?