Order Count - Date measure

Anonymous — Fri, 14 Sep 2018 20:38:52 GMT

Trying to create a measure that will be used in a table for a report. Basically, Report will have individual dates as row with measures as columns and will be used in mornings to check information from day befoe. The measure I am trying to get specifically would count distinct orders from the day before.

So far the expression I have is:

count(DISTINCT{$<[completed_date.autoCalendar.Date]={"$(=Date(max([completed_date])-1))"}>}([order_id]))

This only shows yesterdays (9/13) order total but, I am trying to get something like:

Date Value

9/14/2018 (Order Count from 9/13/2018)

9/13/2018 (Order Count from 9/12/2018)

9/12/2018 (Order Count from 9/11/2018)... so on

Any example of an expression that would do this? I think my expression is close, just not what I need. Thanks in advance.

topic Order Count - Date measure in App Development

Order Count - Date measure