Forum Discussion
Calculating sum from powerbi model
I have created a simple 2 column table on my powerbi desktop using "Table" in the visualizations.
I dragged in a measure column [ sale_date ] and a dimension column [numer_of_widgets].
The dimension column I just want to get the sum of the whole column.
I cant use powerquery due to security reasons, so all I have is powerbi desktop and I want to hopefully create a measure using DAX so I can take the sum of [numer_of_widgets] column and make it available via a measure, so I can graph the answer.
I could use a calculated column but dont know how to get the sum of a calculated column and make it available like a measure so it can be graphed.
When I try to do a =sum(<table.[column]) I cant seem to get it to work.
I'm strugging to understand whats wrong as Ive been given this task, but not a lot of training.
Any help would be really appreciated. Thank you.
4 Replies
Hi Anonymous
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Anonymous,
Thank you for reaching out in Microsoft Community Forum.
Thank you Ritaf1983 for the helpful response.
As suggested by Ritaf1983 , Please provide some sample data, clearly explain the question you're trying to ask, and specify what outcome you expect.
Please continue using Microsoft community forum
Regards,
Pavan.
