Discount count total by filter

[icturion]

Hello,

I am trying to count the total number of unique values ​​from column number of which in column type have values a, c or f.

I think I should make a measure with a filter in it. I have the following:

measure =

VAR​ filter = Filter(table);
table[type] = "a"
|| table[type] = "c"
|| table[type] = "f"

VAR VAR2 = Filter(table; table[number])

RETURN​

calculated( [measure =]; ​

filter; ​VAR2

but I keep getting an error: Syntax error, at line 3, col 17

I don't understand what I'm doing wrong, hopefully someone can help me.

thank you

[v-deddai1-msft · Accepted solution]

Hi @icturion ,

Would you please try to use the following measure?

Measure =

CALCULATE (

    SUM ( 'Table '[number] ),

    FILTER ( 'Table', 'Table'[type] IN { "a", "b", "f" } )

)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai