Summarize function beginner problem

[Anonymous]

Hello Guys!

I know these are dumb question but I'm totally new here. Please bear with me, I'm sorry.

Ok so I have these products below and I want to create this table.

Table: Product

Product Name	Total	Calculator	Charger	Cable
Calculator	6	3	5	2
Charger	12	2	4	2
Cable	7	1	3	3

I have this query:

Product = SUMMARIZE('Product','Product'[Product Name], "Total", SUM ('Product'[Calculator]))

And the result is:

Product Name	Total
	6
Calculator	3
Charger	2
Cable	1

I just want to put the TOTAL amount in to the second row in Total column. Also I want to filter these products by MonthYear and Branch. Do you guys have idea on how to do it? I could totally use some tutorials.

Again, Im really sorry for these dumb question and Thank you very much for your help.

[Jimmy801 · Accepted solution]

Hello @Anonymous 

this DAX-code will not provide any totals. To add the total put around the second parameter a ROLLUP-function. But anyway, in a database the position is not important, so there is no way to decide where the rollup is showing up, it's always put at the end. You could use power query to solve this.

About your second question, yes you can filter them by time dimension, but you have to have a column in your fact-table that showing a time reference.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Anonymous]

Thank you so much @Jimmy801 ! 🙂