cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Shwam Helper I
Helper I

Help with SUMMARIZE fucntion

Hi Guys,

 

trying to write a completely simple summarize function.

 

Fucntion: SUMMARIZE CUST TYPE = SUMMARIZE(MASTER,MASTER[Customer_Type_Description],"COUNT",COUNTROWS(MASTER))

 

I keep receivng an error - THE EXPRESSION REFERS TO MULTIPLE COLUMNS. MULTIPLE COLUMNS CANNOT BE CONVERTED TO A SCCALAR VALUE.

I do not understand this as I am trying to use 1 column.

 

I am looking at our table called master where there are unique IDs for each line item (relating to a work item ID).

 

Each of the work items will have a Customer Type Description.

 

I am trying to get a count of each Customer Type Description in the summarize function so that I can calculate a median on that.

 

(Ultimate goal is to calculate the median of the count of work items per customer type).

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Shwam Helper I
Helper I

Re: Help with SUMMARIZE fucntion

Nevermind me.

 

Put my summarize inside of a medianx.

 

MEDIAN MONTHLY = CALCULATE(MEDIANX(SUMMARIZE(MASTER,MASTER[Work_Item_Last_Activity_Date].[Month],"COUNT",COUNTROWS(MASTER)),[COUNT]))

 

Looks like it's working.

 

Busy vetting results.

View solution in original post

1 REPLY 1
Shwam Helper I
Helper I

Re: Help with SUMMARIZE fucntion

Nevermind me.

 

Put my summarize inside of a medianx.

 

MEDIAN MONTHLY = CALCULATE(MEDIANX(SUMMARIZE(MASTER,MASTER[Work_Item_Last_Activity_Date].[Month],"COUNT",COUNTROWS(MASTER)),[COUNT]))

 

Looks like it's working.

 

Busy vetting results.

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors