Forum Discussion
Relationship with 3 tables in Direct Query
Anonymous
To count sales id:
calculate( distinctcount( order line[sales id ] ), Sales order[status]="closed")
to count workers:
calculate( count( sales order[workers] ), Sales order[status]="closed", order line)
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply š
Hi Fowmy ,
Sorry my mistakes, if sum sales amount, which is on the Transactions table side.. it is working. But actually there is another measure which Count of Sales Id... by which I counting the one in Sales Table instead.
So do I need to count Sales Id in Trans instead ?
Just one question what if there is other field in Sales Table that I want to count ? So forexample, I added new column in Sales Id, lets say 'Worker", and I want to count this, like :
Count worker by Group if Status = Closed
Thanks,
Anonymous
To count sales id:
calculate( distinctcount( order line[sales id ] ), Sales order[status]="closed")
to count workers:
calculate( count( sales order[workers] ), Sales order[status]="closed", order line)
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply š