Forum Discussion
Relationship with 3 tables in Direct Query
Hello everyone, Need a little help. I have 3 tables like below: If I want to calculate Sales amount by Item group which the Sales Order Status is "Closed". What will be the DAX ? I was th...
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 🙂
Anonymous
Create the following measure and place it on table visual with Group field,
Sales Amount = CALCULATE(SUM(OrderLine[Amount]),SalesOrder[Status]="Closed")________________________
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 🙂