Forum Discussion
Solved
Filter or virtual table
I have a measure where I calculate a percentage, I need to count the records that have a percentage greater than or equal to 80 but I can't do this filter and count all the measures that I try do n...
Don't have enough info about your model, but just by looking at your measure, try to replace it with:
vM80 =CALCULATE(DISTINCTCOUNT([CO_MUNICIPIO]),F_Dados[c_CV Geral]>=80))
it as if you will write:vM80 =CALCULATE(DISTINCTCOUNT([CO_MUNICIPIO]),FILTER(ALL(F_Dados[c_CV Geral]),F_Dados[c_CV Geral]>=80))
which is different substentially than what you wrote so maybe it will solve your problem quicklyI tried it before but it didn't work
Don't have enough info about your model, but just by looking at your measure, try to replace it with:
vM80 =
CALCULATE(
DISTINCTCOUNT([CO_MUNICIPIO]),
F_Dados[c_CV Geral]>=80)
)
it as if you will write:
vM80 =
CALCULATE(
DISTINCTCOUNT([CO_MUNICIPIO]),
FILTER(ALL(F_Dados[c_CV Geral]),F_Dados[c_CV Geral]>=80)
)
which is different substentially than what you wrote so maybe it will solve your problem quickly
which is different substentially than what you wrote so maybe it will solve your problem quickly
Thanks for the answer, but, when trying to use the measure as proposed, it returns the message "It is not possible to find the column 'c_CV Geral' in the table 'F_Dados' or it is not allowed to use it in this expression" only reinforcing the column "c_CV Geral" is a calculated measure, I changed the column "c_CV Geral" for a fixed one, but it always returns 1 for all rows