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

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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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

Capture1.jpg

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