Forum Discussion
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 not return the items as if I didn't identify which ones have this value.
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
13 Replies
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 quicklyThanks 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?
Try:
vM80 = CALCULATE ( DISTINCTCOUNT ( 'Table'[CO_MUNICIPIO] ), FILTER ( F_Dados, [CV %] >= 80 ) )Change 'Table' to whatever table the [CO_MUNICIPIO] is in
Hi hugors ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Flag = IF( [CV %] >=80,1,0)discount = CALCULATE(DISTINCTCOUNT(F_Dados[ID]),ALLSELECTED('F_Dados'))2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
The solution is interesting but it didn't work either, I'm believing that it may be an association problem between the models. I keep trying, thanks for the help
I managed to solve it, THANK YOU ALL
Good afternoon, I managed to solve it was a relationship problem between the dimensions
