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, it is a measure I can forward the file, do you have an email
Hi,
Share the download link of your PBI file.