Forum Discussion

aditi11's avatar
aditi11
Frequent Visitor
3 years ago
Solved

undefined

Hello team, I want to calculate

 

 the length of the product description of only those products whose product color is NA.

Using ONLY string functions.

Thanks in advance. 

  • Hi, aditi11 

     

    Sample data:

    Measure =
    CALCULATE (
        COUNT ( 'Table'[Product] ),
        FILTER ( ALL ( 'Table' ), [ProductColor] = "NA" )
    )
    

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support

    Hi, aditi11 

     

    Sample data:

    Measure =
    CALCULATE (
        COUNT ( 'Table'[Product] ),
        FILTER ( ALL ( 'Table' ), [ProductColor] = "NA" )
    )
    

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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