Forum Discussion

Kurague's avatar
Kurague
Regular Visitor
9 years ago

add filters with calculation

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.

2 Replies

  • Kurague's avatar
    Kurague
    Regular Visitor

    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's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Kurague,

     

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

    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