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
A 'PLACEHOLDER' function was used in a True/False expression used as a table filter expression. This is not allowed.