Counting unique orders in a table

[mwaltercpa]

I have a sales order table where each order may have multiple records. Order 1.A, 1.B, 1.C. In Excel, I would separate out order #1 from the line letters, and do an Array formula and just divide 1 by the total. i.e. 1/3=.33, 1/3=.33, 1/3=.33. Summing this in my pivot table would show me that order 1 = 1 order.

How can I recreate this is PowerPivot as a calculated field? Is there a way to reproduce this array formula?

Thanks!

 

[scottsen]

Since I am lame with standard excel, I am having a hard time answer your question. Based on the subject/topic of your post, I would use DISTINCTCOUNT(Orders[OrderId]), but... is that what you need?

 

[mwaltercpa]

Thanks, that was perfect!! I'm fairly new to PP and enjoying how logical it is to operate