Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 XXXX 100 100
XYZ AAAA 200 300
I need to get RTotal Column . i tried using Quick Measure - Running total but it didnt work stating MAx function can work only on numbers and not string (Category)
So need help for the same
Pls suggest
Solved! Go to Solution.
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
Hi , @GuestUser
Could you please tell me whether your problem has been solved?
If it is, please mark the helpful replies or add your reply as Answered to close this thread?
Best Regards,
Community Support Team _ Eason
Hi , @GuestUser
If your want to change the type of sales from "text"to "decimal number",you need to do some change in SSAS model.
Please refer to this post to change your type of sales from "text" to " decimal number" in SSAS.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I dont think isssue is with Sales Column.
Let me try to explain again :
When I select - New Quick Measure - RunningTotal . It assks for following things
Base value - Sales Amount
Field - Category ( It takes only columns and not measures)
Direction - Descending
and it will create measure with below formula
Measure =
Which is giving error - like MAX cannot work on String Data Types
Hope I am clear.
Any suggestions . Basically i need to achieve cumulative Total .
Any other formula /way to achieve the same ?
Hi , @GuestUser
Try measure as below:
Measure =
CALCULATE (
[Sales],
FILTER (
ALLSELECTED ( 'Table'[Category] ),
'Table'[Category] <= SELECTEDVALUE ( 'Table'[Category] )
)
)
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-easonf-msft
Selectvalue function is not recognized in the version of dax which i am using
Any other alternative pls?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
50 | |
18 | |
17 | |
16 | |
8 |