# Detail of Sales in progress

I need to show the detail of Invoices to be authorized.

The situation is basically same as Sam explain in the tutorial of Sales in Progress.

I can now calculate the numbers of “invoices in progress” but I need to go the next level, which is the detail of those invoices. In Sam examples is the details of the invoices in progress.

I am thinking in use a Drill Through, but I am strangling to bring the get the detail information.

In my file attached, I would like to see the 8 sales in progress for the 6/1/2014.

Any tip of direction is much appreciated it

Kind regards,
Ezequiel

Here is the file!
Events in Progress Eze.pbix (546.6 KB)

Hi @ezenunez
Thanks for the thorough explanation.
I’ve created two measures and used them to solve your problem.
By working with the attached file, I found that the “Order in Progress” measure is somehow a cumulative measure. So, I decided to write a new measure called “Order in Progress 2” which is NOT cumulative and added it to the table you created.

``````Orders in Progress 2 = CALCULATE(
COUNTROWS( 'Sales Data' ),
FILTER( VALUES( 'Sales Data'[OrderDate] ), 'Sales Data'[OrderDate] <= MAX( Dates[Date] ) ),
FILTER( VALUES( 'Sales Data'[OrderDate] ), 'Sales Data'[OrderDate] >= MAX( Dates[Date] ) ))
``````

Besides that, I created a new table consisting of Order Number, Order Date, and Channel. I created “Order Date” measure to bring the order date column into this new table using a measure.

``````Order Date = CALCULATE(
SELECTEDVALUE( 'Sales Data'[OrderDate] ) ,
USERELATIONSHIP( Dates[Date] , 'Sales Data'[OrderDate] ) )
``````

Now by selecting one row in the left table you can find the details about the shipments on that date based on the order date.

Best

Events in Progress Eze.pbix (543.0 KB)