Forum Discussion
Solved
aggregates
I have a query that I want to make a simple chart for, count the number of items an employee has picked. When I create the chart the "values" dropdown only lists "count". I want to sum. why do I n...
Zsivago I'll assume you are working with Power BI Desktop.
What it sounds like you need is a measure created. We'll call it "Total_Items"
Right click your table in either the data or report view - > New Measure
In the field paste Total_Items:=SUM(<Tablename>[<FieldName>])
May the datatype is set to String. Set the data type to numeric type . ( Select the fied inthe field list and look for data type under Modelling ribbon tab)
Zsivago I'll assume you are working with Power BI Desktop.
What it sounds like you need is a measure created. We'll call it "Total_Items"
Right click your table in either the data or report view - > New Measure
In the field paste Total_Items:=SUM(<Tablename>[<FieldName>])