Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
giovanna2021
Contributor

Doubt Count Distinct Conditional one condition or another

Helo guys,

I need to count how many distinct clients are buying one category or another category of my products, how do I do that.

count(distinct {<[Brand]={"Blue"} or [Brand]={"Red"}>}[clients code])

I tried to use or and its not calculating.

1 Reply
Taoufiq_Zarra

@giovanna2021  like ?

count(distinct {<[Brand]={'Blue','Red'} >}[clients code])
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉