Power BI - Formula Help

[micky007]

Hi Everyone,

Let me first start of by saying Happy New Year! Not sure if saying that is worth much as its looks like this year is just going to be a repeat of last year. But anyway....

I have a formula I'm using in a Measurement in Power BI, but i want to filter it a bit more but my understanding is only 2 filters can be applied so not too sure how to go about doing what I'm after. Below is the formula:

Please Login or Register  to view this content.

So that formula will count all the registrations by week, but I'd like to filter it more to by adding:

Please Login or Register  to view this content.

So that way it will only count the registrations by week with the registration type as "InDirect".

Can anyone help me with this please?

Thank you in advance and I hope you & the family are all well and staying safe!

[CK76]

You mean something like... below?
In DAX && is used as AND operator in condition expression. And || for OR operator.

Please Login or Register  to view this content.

EDIT: You can find more about operators in link below. For && etc, see Logical Operator section.

https://docs.microsoft.com/en-us/dax...ator-reference

[micky007]

Hi CK76,

Thank you for this, was exactly what i was looking for!

Much appreciated.