Forum Discussion
Helper IVCreate a running total that changes on filtered records
Wow all you numbers must Data Type: Text - all seem to be left justified and that explains lack of totals!
Go to Modeling Tab and Check Data Type: for each Field in your table
Community Champion
Can you write on the image or somehow mark what fields you are referring to?
why do you have different field names in the 2 visualizations?
for example why Total Revenue and RevenueTotal? That should be the same?
what field do you want to have a running total for? You can do this with DAX
Total Revenue = SUM (tablename[Revenue Column])
Running Total = CALCULATE ( [Total Revenue], FILTER ( ALL (tablename), tablename[Date Column] <= MAX(tablename[Date Column] ) ) )
Reminder: This is DAX so don't do this in the Query Editor
go to the table that contains Revenue column => go to Modeling Tab => click New Measure and type there
kfschaeferIs there another way to display the total on the same visualization?, where it is display always at the bottom without scrolling?
- Sean
If your table has items only in the Values - then the Total Row is fixed - even if you have scroll bars it will remain visible.
if you also have items in the Rows then you will have to scroll down.
No you can't change the location of the total row!
- kfschaefer
Please explain this? I am new to this?
"If your table has items only in the Values - then the Total Row is fixed - even if you have scroll bars it will remain visible."
My table has numerous values and I thought group on that table would get me the running total, however, this gets me a static value not changable by the slicers.
K