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
Helper IVIs 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
- Sean
Never mind in a table all you have is Values. In a Matrix you can have Rows and Columns along with the Values.
bottomline your total row in a table should always be visible on the bottom row
with or without scroll bars it stays fixed and always visible
make sure it's turned on in the options - but it comes on by default anyway
as fas as the running total did you try my DAX formula