Forum Discussion
aditi11
3 years agoFrequent Visitor
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-zhangtiCommunity 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.