Forum Discussion

icturion's avatar
icturion
Icon for Resolver II rankResolver 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 hav...
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

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity 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