Forum Discussion

clarissa's avatar
clarissa
Icon for Helper I rankHelper I
6 years ago

distinct count with condition

Hello  How can I count distinct order_no which are only coming from specific traffic sources  (google, mail, bing)? So the distinctcount happens based on a pre-filtered data set (traffic sources). Th...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi clarissa ,

 

Can you share a sample .pbix file.

 

Regards,

HN

clarissa's avatar
clarissa
Icon for Helper I rankHelper I
6 years ago

Hi Anonymous 

Unfortunately not, but here the data modell

 

 

Does that help? B2C_unique_order_number is joined with the 2 other tables with the order-no (1 to *)