Count percentage values in measures
Hello, everyone! I would like to count the number of values in a measure that is under 30%, the number of values in the same measure between 30% and 50% and the number of values that are above 80%. The measure with the percentage values is: % Executada = if(sum(Projetos[Orçamento DIretoria])=0,Blank(),DIVIDE(SUM('Tarefas'[Realizado]),SUM(Tarefas[Custo Atual]),0)) It returns this: I've tried COUNTA, COUNTAX with filters, if, calculate, and it always returns 1, as the card above the table shows for the percentages below 30%. What am i missing in my knowledge? Thanks for the help!
