A table of multiple values was supplied where a single value was expected how to handle this error

[Pawan]

Hi ,

I have used below expression in one report and it's refreshing successfully till now. But when i have refreshed the app today getting below error. "A table of multiple values was supplied where a single value was expected"

Please help me to fix this error.

CC_UserID = var summ = SUMMARIZE(FILTER(CT_Users,CT_Users[UserGuid]=CT_Report_Page_View[UserId]),CT_Users[UniqueUserName])

return

summ

Thanks

[Arul]

@Pawan ,

Was it a calculated table or measure?

Thanks,

Arul

[Pawan]

@Arul It's a measure

[Arul]

@Pawan ,

Then it won't work. Because return type of SUMMARIZE function is a table but you are expecting that needs to be return in a measure whereas measure returns only a scalar value not the table with columns.

SUMMARIZE - Check this documentation for the return type of SUMMAZRIZE.

Thanks,

Arul