Forum Discussion
Solved
Running Total Issue
Hi , Need help in creating running total column We are creating report using Connect Live option - SSAS Tabular I have report in below format Category Name Sales RTotal ABC ...
Hi, GuestUser
Please provide more details .（Where did you write your measure）
Theoretically no matter in the directquery or live connect mode, Selectvalue function all can be recognized in PowerBI Desktop.
Best Regards,
Community Support Team _ Eason
Sounds like you potentially need to switch Sales from being a Text field to a numeric field in your SSAS model.
Sales is a measure column which is sum of sales_amount which is numeric only