Forum Discussion
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.
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.