How to filter with 2 condition in a measure

[luisreyes]

Hi,

Im trying to use CALCULATE with 2 filters: 

Measure= CALCULATE(SUM(Hoja2[Cantidad]),Hoja2[Tipo]="No Consumidos",Hoja2[Tipo]="Ligero No Consumido")

i want to filter by 2 types to sum (No Consumidos, Ligero No Consumido), 

I managed to graph with only 1 type but i need the 2 types, to make a graph like this:

[Anonymous · Accepted solution]

Hi @luisreyes ,

Please try:

Measure = 
CALCULATE(
    SUM('Hoja2'[Cantidad]),
        FILTER(
            'Hoja2',
            'Hoja2'[Tipo]="No Consumidos"
                ||'Hoja2'[Tipo]="Ligero No Consumido"
        )
)

or

Measure = 
CALCULATE(
    SUM('Hoja2'[Cantidad]),
        FILTER(
            'Hoja2',
            'Hoja2'[Tipo] IN {"No Consumidos","Ligero No Consumido"}       
        )
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[mariussve1]

You should be able to filter multiple columns with CALCULATE().

Can you please look at this link for concept and get back if you still have any questions 🙂

https://www.sqlbi.com/articles/specifying-multiple-filter-conditions-in-calculate/

Br

Marius