Average number of cities

[Anonymous]

Hello guys,

I have the following tables.

My question is how to get the average number of different cities where any product has been sold. I dont now the expected outcome, becuase I didnt understand the requirement, I hope that my question is comprehensible. 

Best Regards

[v-piga-msft]

Hi @Anonymous ,

More details will be more helpful.

If it is convenient, please share some data sample which could reproduce your scenario and your desired output so that we could get the solution quickly.

Please refer to this blog how to get your question answered quickly.

Best  Regards,

Cherry

[Anonymous]

thanks

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry