Measure that shows the max date per order

[Maaike_zeevalk]

Hi! 

I'm building a table that shows information about different orders, like this:

In this example I have filtered to 1 order, in reality there's more.

The orders can have several delivery dates. I want to show one row per order, with the max delivery date. The amount ordered and amount delivered should show the total of all deliveries. So in this example amount ordered: 17, amount delivered: 17. 

This is a simple drawing of the data model:

I'm using a live connection, so would prefer to solve this using measures.

I am able to make changes to the model if neccesary.

[sjoerdvn · Accepted solution]

You should be sharing more information on your model, but let me give you some hints..
If you have the delivery dates in your fact_orderlines then it is simply something like MAX(fact_orderlines[delivery_date]).
If your are linking to the date dimension with a non-date column, using single direction, you will need to crossfilter the dimension and then it will be something like CALCULATE(MAX(dim_date_delivered[date]),CROSSFILTER(dim_date_delivered[id], fact_orderlines[delivery_date_id], BOTH)

[Maaike_zeevalk]

I am indeed linking with a non-date column with single direction. Your suggestion worked perfectly, thanks a lot.