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,
Unfortunately, I can't use Dual mode as well. The rule here is 'pure' Direct Query 😅
Fowmy , yeah for the amount measure I have created like your example, and after put in the Group, all rows displaying same value (which is the total), is like the filter on the relationship is not working
Thanks
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 🙂