add filters with calculation

[Kurague]

Greetings everyone, I have been fiddling with my Power BI, and I can't seem to get this done right, so I'll resort on asking.

The problem here is, I need to COUNT all the values in "Idiomas", cept for "es, es-ES,es-41,es-419, es-tradnl and (blank space because this one has no value name to it)", and I just can't do it. I need to make the measure to use it in another calculation, so I can't use the "easy visual filter".

Any thoughts on this? Ask for any information you may need.

[v-ljerr-msft]

Hi @Kurague,

If I understand you correctly, the formula below should work in your scenario. 

measure =
CALCULATE (
    COUNTA ( 'Table1'[Idiomas] ),
    FILTER (
        'Table1',
        'Table1'[Idiomas] <> "es"
            && 'Table1'[Idiomas] <> "es-ES"
            && 'Table1'[Idiomas] <> "es-41"
            && 'Table1'[Idiomas] <> "es-419"
            && 'Table1'[Idiomas] <> "es-tradnl"
            && 'Table1'[Idiomas] <> ""
            && 'Table1'[Idiomas] <> BLANK ()
    )
)

Regards

[Kurague]

Greetings everyone, I have been fiddling with my Power BI, and I can't seem to get this done right, so I'll resort on asking.

The problem here is, I need to COUNT all the values in "Idiomas", cept for "es, es-ES,es-41,es-419, es-tradnl and (blank space because this one has no value name to it)", and I just can't do it. I need to make the measure to use it in another calculation, so I can't use the "easy visual filter".

Any thoughts on this? Ask for any information you may need.