undefined

[aditi11]

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. 

[v-zhangti · Accepted solution]

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.