Calculate with a filter on 2 fields

[e175429]

Hey All,

I would like to create a measure that shows me "how many of bytes are promoters"?

I created this measure:

BSS Promoter = COUNTX(FILTER(Cleaned, Cleaned[ID] = "Promoter"), Cleaned[Section.] = "bytes")

But that gives me a error.

Cleaned = table name

NPS = field

Section = field

So, how do I create a measure with a filter on 2 columns?

Thank you!

[e175429 · Accepted solution]

I figured it out. I had to put calculate first. 

so its:

BSS Promoter = CALCULATE(COUNTROWS(Cleaned),

                           FILTER(Cleaned, Cleaned[ID] = "Promoter"),

                           FILTER(cleaned, cleaned[Section.]="bytes"))

[FreemanZ]

hi @e175429 

Try like:

BSS Promoter =

COUNTROWS(

    FILTER(

        Cleaned, 

        Cleaned[ID] = "Promoter"

            &&Cleaned[Section] = "bytes"

     )

)

[e175429]

When I try that, I get this error: