Solved: undefined

aditi11 · ‎11-23-2022

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 · ‎11-23-2022

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.

v-zhangti · ‎11-23-2022

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.

undefined