Column to toggle between single or multiple categories

I want to create a column that allows me to toggle between emails associated with single or multiple clients (categories). I have a stacked column chart with the following fields. Axis: 'Email' ...

niko18033

Helper I

6 years ago

vivran22

Thanks, Vivek. I tried that, but it seems to be extremely processor/RAM intensive. It ran for almost an hour but failed due a lack of system resources. I tried a workaround, by creating a column rather than a measure. This way, the user also has the option whethere or not to filter out the "single" client emails. I'm trying to do a column that yields two values: "Single" or "Multiple", referring to the number of clients associated with the email.

However, I'm getting this error. Am I missing something?

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

Multiple Clients? =

VAR StepTable =

SUMMARIZE(

'Table1',

Table1[Email],

"Client Count", DISTINCTCOUNT('Table1'[CLIENT_NAME]),

"Request Count", [Request Count])

//Filter out records with single client

RETURN

IF(FILTER(StepTable, [Client Count] > 1), "Multiple", "Single")