CODEWITHSUNDEEP
powerbidax
Mishi
Mishi

Reputation: 55

Error 'The expression refers to multiple columns

Does anyone know why this measure is throwing up an error 'The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

MALS Lastweek =
CALCULATE (
    COUNT ( vw_sana_account[new_mal] ) = 1
        && FILTER ( DateTable, DateTable[LastWeek] = "Yes" )
)

Upvotes: 0

Views: 627

Answers (1)

Strawberryshrub
Strawberryshrub

Reputation: 3399

Yep, your syntax is wrong. This is what you are looking for:

MALS Lastweek = Calculate(Count(vw_sana_account[new_mal]), DateTable[LastWeek]="Yes")

You dont need Count() = 1. It does automatically add 1 in the count function and if you use Calculate() your second argument is the filter.

This measure needs a relationship between the vw_sana_account and the DateTable tables by the way.

Upvotes: 0

Related Questions