Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
Hi @nsessa ,
Please let us know whether @jdbuchanan71 's expression is what you want.
Best Regards,
Icey
Hi,
Share some data and show the expected result.
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |