Forum Discussion
Filter or virtual table
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:
it as if you will write:
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
A 'PLACEHOLDER' function was used in a True/False expression used as a table filter expression. This is not allowed.
Yes, because it's a measure. Your code had a table name before that, which indicates that its a column :).
It won't work in the way I wrote it if "c_CV Geral is a measure .
In this case I do need more info about your model. Can you share the file?
Yes, it is a measure I can forward the file, do you have an email