aggregates

[Zsivago]

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?

[Seth_C_Bauer · Accepted solution]

@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>])

[Zsivago]

Worked like a charm!

[meysun · Accepted solution]

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)

[jewelry]

where is the modelling tab to change from "string" to "numeric" 

[Seth_C_Bauer]

@jewelry this is what you are looking for, in the header of the Data view in PBI desktop.

[jewelry]

@Seth_C_Bauer thank you for your quick response. Is there an option to see the modelling tab in the web interface? 

[Seth_C_Bauer]

@jewelry the modeling component of Power BI exists in the Desktop only.

[jewelry]

@Eno1978 I just downloaded the desktop version and I signed into my account. I already had reports in the web interface version but am not seeing any of the reports in the desktop version. Is there a way to sync or import my existing reports from the web into the desktop version?

[Seth_C_Bauer]

@jewelry ugh, unfortunetely not at this time. We're all hoping for some export ability soon. Currently, it is a one way street. You can only publish desktop files to the Service, there is no current way to pull down a report that was created in the Service back down to the Desktop...

[Seth_C_Bauer · Accepted solution]

@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>])