ljtrzebinski
New Member
- Joined
- Jul 7, 2016
- Messages
- 6
Hello all,
I hope that there is a solution to a specific issue I run into. I have two different sales table one is for all "organic sales" and the other one is for sales that resulted as part of "order sharing" process between other companies". Both data tables have a relationship to a job table that has specific job number associated to each sales I am trying to calculate total number of providers on assignment regardless if the sale was organic or part of the order sharing. I am able to calculate number of providers for order sharing and number of providers for organic sales. But is it possible to get distinct number of providers on assignment regardless where the order initiate? Currently I have couple providers that are listed in both.
Number of providers Organic:=calculate(distincount(Jobs[Provider_Name]),OrganicSales)
Number of Providers OrderSharing:=calculate(distincount(jobs[Provider_name]),OrderSharing)
Number of providers All:=calculate(distincount(jobs[Provider_Name]),OrganicSales&&OrderSharing) - Error The Expression refers to multiply columns. Multiply columns cant be converted to scalar value.
Is there another way to do this?
Thanks,
I hope that there is a solution to a specific issue I run into. I have two different sales table one is for all "organic sales" and the other one is for sales that resulted as part of "order sharing" process between other companies". Both data tables have a relationship to a job table that has specific job number associated to each sales I am trying to calculate total number of providers on assignment regardless if the sale was organic or part of the order sharing. I am able to calculate number of providers for order sharing and number of providers for organic sales. But is it possible to get distinct number of providers on assignment regardless where the order initiate? Currently I have couple providers that are listed in both.
Number of providers Organic:=calculate(distincount(Jobs[Provider_Name]),OrganicSales)
Number of Providers OrderSharing:=calculate(distincount(jobs[Provider_name]),OrderSharing)
Number of providers All:=calculate(distincount(jobs[Provider_Name]),OrganicSales&&OrderSharing) - Error The Expression refers to multiply columns. Multiply columns cant be converted to scalar value.
Is there another way to do this?
Thanks,