Forum Discussion
Summarize function beginner problem
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 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.
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
2 Replies
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
JimmyThank you so much Jimmy801 ! 🙂