Help with Complex DAX please

[SebastianColombia]

Hi to everyone, I really need your help with a DAX I need to create.

I have the following pivot table in which I count the number of products per month. I need a DAX in the second column that sums and shows the total of orders. Is that possible?? Thanks a lot!!!.

[TABLE="width: 147"]
<colgroup><col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;" width="92"> <col style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;" width="49"> <tbody>[TR]
[TD="class: xl145, width: 55, bgcolor: #DCE6F1"]Months[/TD]
[TD="class: xl145, width: 92, bgcolor: #DCE6F1"]NumProducts[/TD]
[TD="class: xl145, width: 49, bgcolor: #DCE6F1"]Dax[/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]jan[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]145[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]feb[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]256[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]mar[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]467[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]apr[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]178[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]may[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]339[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]jun[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]370[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]jul[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]401[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]aug[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]432[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]sep[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]463[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]oct[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]494[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]nov[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]525[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]dec[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]556[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]TOTAL[/TD]
[TD="class: xl147, bgcolor: transparent, align: right"]4626[/TD]
[TD="class: xl148, bgcolor: transparent"] 4.626 [/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 147"]
<colgroup><col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;" width="92"> <col style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;" width="49"> <tbody>[TR]
[TD="class: xl147, width: 55, bgcolor: #DCE6F1"]Months[/TD]
[TD="class: xl147, width: 92, bgcolor: #DCE6F1"]NumProducts[/TD]
[TD="class: xl147, width: 49, bgcolor: #DCE6F1"]Dax[/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]jan[/TD]
[TD="bgcolor: transparent, align: right"]145[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]feb[/TD]
[TD="bgcolor: transparent, align: right"]256[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]mar[/TD]
[TD="bgcolor: transparent, align: right"]467[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]apr[/TD]
[TD="bgcolor: transparent, align: right"]178[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]may[/TD]
[TD="bgcolor: transparent, align: right"]339[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]jun[/TD]
[TD="bgcolor: transparent, align: right"]370[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]jul[/TD]
[TD="bgcolor: transparent, align: right"]401[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]aug[/TD]
[TD="bgcolor: transparent, align: right"]432[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]sep[/TD]
[TD="bgcolor: transparent, align: right"]463[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]oct[/TD]
[TD="bgcolor: transparent, align: right"]494[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]nov[/TD]
[TD="bgcolor: transparent, align: right"]525[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
[TR]
[TD="class: xl146, bgcolor: transparent"]dec[/TD]
[TD="bgcolor: transparent, align: right"]556[/TD]
[TD="class: xl145, bgcolor: transparent"] 4.626 [/TD]
[/TR]
</tbody>[/TABLE]

 

[Matt Allington]

Yes it is possible, and not complex. But you need to share what your source data looks like, not what the pivot table looks like. To calculate the total orders, you need an order id. Then use DISTINCTCOUNT(data[orderID]).