Forum Discussion

icturion's avatar
icturion
Resolver II
6 years ago
Solved

Discount count total by filter

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

Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    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

1 Reply

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    6 years ago

    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