Table of multiple values error

[SteveIOW]

Good morning.

I have created a measure with two variables, the output of which is dependent on a selection from another table.

ActivityActual =

VAR vActW = CALCULATE(SUM(MainFacts[Value]), MainFacts[MetricType] = "Activity", MainFacts[DataSource] = "WAR MH", MainFacts[Frequency] = "Weekly")

VAR vActM = CALCULATE(SUM(MainFacts[Value]), MainFacts[MetricType] = "Activity", MainFacts[DataSource] = "DM01 MH", MainFacts[Frequency] = "Monthly")

RETURN

IF('DataF' = "Monthly", vActM, vActW)

The measure works fine if I Return either vActM or vActW.

The field DataF is in a table with only two values in it - Weekly or Monthly.

The same process works in other measures I have created. but in this one I get the error...

 I am completely stuck. can any one help please?

Kind regards

Steve

[danextian]

In addition, that is because your measure expects a single or scalar value. Column 'DataF' is a column and is not a single value. The workaround is to wrap it in a functoin that will return and a single value which doesn't necessarily aggreate like MAX, MIN, SELECTEDVALUE. This functions will return just about the same value on a by row basis but not when it comes to the total. Took me some time too to figure out when I was a novice Power BI user.

[danextian · Accepted solution]

Try changing IF('DataF' = "Monthly", vActM, vActW) to IF(SELECTEDVALUE('TableName'[ColumnName]) = "Monthly", vActM, vActW). Change 'TableName'[ColumnName]  to the actual table and column names.

[SteveIOW]

spot on - thank you so much