Help with SUMMARIZE fucntion

[Anonymous]

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.

[Anonymous · Accepted solution]

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.