Forum Discussion

Zsivago's avatar
Zsivago
New Member
10 years ago
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...
  • Anonymous's avatar
    Anonymous
    10 years ago

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

  • meysun's avatar
    meysun
    10 years ago

    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's avatar
jewelry
Regular Visitor
10 years ago

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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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

  • jewelry's avatar
    jewelry
    Regular Visitor
    10 years ago

    @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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      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...