Forum Discussion

pakovic's avatar
pakovic
Icon for Helper I rankHelper 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 ...
Need Help
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper 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
Icon for Helper I rankHelper 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?