Forum Discussion

hugors's avatar
hugors
Regular Visitor
4 years ago
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...
Data Protection
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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's avatar
    hugors
    4 years ago

    I tried it before but it didn't work

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Try:

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

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

  • hugors's avatar
    hugors
    Regular Visitor
    4 years ago

    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

  • hugors's avatar
    hugors
    Regular Visitor
    4 years ago

    I tried it before but it didn't work