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