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
in that case them you could create the data table by making a new direct query and using SQL statement in the advance option segment of the data source to make the source return you the table joined with both table information, basically make the relationship join on the source and get it to your data model.
here you state that table join to the source to handle and return the combined table (on SQL languague).