Creating a new table with summarizing and distinct count

[nsessa]

Hi, 

I am trying to create a new table that will summarize some information I need. The new table will have 3 columns. I want to summarize a date column, and a zip column. However I want the third column to be a distinct count of 'orders' going to that zip code on that date. I understand i can do the summarize function for the first 2 columns, but I am having trouble with getting the third column in the table. 

Thank you

[Icey]

Hi @nsessa ,

Please let us know whether @jdbuchanan71 's expression is what you want.

Best Regards,

Icey

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[jdbuchanan71 · Accepted solution]

@nsessa 

Something like this should get you the table you are looking for.

Table 2 = SUMMARIZE('Table','Table'[Date],'Table'[Zip],"Orders",DISTINCTCOUNT('Table'[Order Num]))

 You will need to change the "Order" calculation to be applicable to your model.