CODEWITHSUNDEEP
powerbidax
Lord Helmet
Lord Helmet

Reputation: 170

Power BI - DAX - Cannot be Converted to a Scalar Value

I think there's nothing wrong with this, but PBI disagrees:

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

I want this to do more, but I have it stripped down to the bare minimum requirements for troubleshooting. I've tried all kinds of tricks, but nothing seems to be working.

Summarize = SUMMARIZE(
    MailboxStatisticsHistorical,
    MailboxStatisticsHistorical[Date],
    "Distinct", DISTINCTCOUNT(MailboxStatisticsHistorical[Identity])
)

Upvotes: 0

Views: 526

Answers (1)

Peter
Peter

Reputation: 12325

SUMMARIZE returns a calculated table. You can't assign it to a measure. (Measures expect scalar results.) Use the Calculated Table UI instead.

enter image description here

Upvotes: 2

Related Questions