Forum Discussion
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 not get the other value choices?
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)
9 Replies
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)
Worked like a charm!
