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
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
Hi,
Share the download link of your PBI file.
