Filter or virtual table

[hugors]

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.

vM80 =

CALCULATE(

DISTINCTCOUNT([CO_MUNICIPIO]),

FILTER(F_Dados,F_Dados[c_CV Geral]>=80)

)

[SpartaBI · Accepted solution]

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 

[hugors]

Good afternoon, I managed to solve it was a relationship problem between the dimensions

[hugors]

I managed to solve it, THANK YOU ALL

[v-yangliu-msft]

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

[hugors]

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

[PaulDBrown]

Try:

vM80 =
CALCULATE ( DISTINCTCOUNT ( 'Table'[CO_MUNICIPIO] ), FILTER ( F_Dados, [CV %] >= 80 ) )

Change 'Table' to whatever table the [CO_MUNICIPIO] is in

[hugors · Accepted solution]

I tried it before but it didn't work

[hugors]

Thanks for the answer, but in the count it returns the total of rows as a result and not just the rows that have the "CV %" greater than or equal to 80

[SpartaBI · Accepted solution]

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 

[hugors]

A 'PLACEHOLDER' function was used in a True/False expression used as a table filter expression. This is not allowed.

[SpartaBI]

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?

[hugors]

Yes, it is a measure I can forward the file, do you have an email

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[hugors]

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