How to use Count with some filters?

[JoanElGran1899]

Hi Everyone!

It's my first post, but I expect it will not be the last one.

My problem is that i want to count the orders which have the next filters, but if the order have the three variables, I only want to count like one order.

I wrote something like this, but was wrong.

Thank you in advance!

[amitchandak]

@JoanElGran1899 , In this one you should remove if , filter with OR(||) seems fine.

If this does not work

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[JoanElGran1899]

@amitchandak Thank you for answer,

I tried OR before but it only accept two conditions, and I have three conditions.

[amitchandak · Accepted solution]

@JoanElGran1899 , You can add any number like

Calculate( [Measure], filter(Table, Table[A1] ="A" || Table[A2] ="B" || Table[A3] ="C"))

another example

Calculate( [Measure], filter(Table, (Table[A1] ="A" || Table[A2] ="B" || Table[A3] ="C") &&  Table[D1] ="D"))