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

Question

Hi all,&nbsp;I googled it couldn't find the answer. Here is my dax function. Can you guys assist?&nbsp;&nbsp;So here is the logic. Count rows that match "25%" string from a Percent column&nbsp;Test = SWITCH(TRUE(),
    
MAX(data[Month]) = "April",
    COUNT(Data[Percent]),FILTER(data,[Percent] = "25%"))

Thanks&nbsp;&nbsp;

v-jiascu-msft · Accepted Answer

Hi,&nbsp;Stuznet
&nbsp;
Try this one, please.
&nbsp;
Test =
SWITCH (
    TRUE (),
    MAX ( data[Month] ) = "April", CALCULATE ( COUNT ( 'Data'[Percent] ), FILTER ( 'data', [Percent] = "25%" ) )
)

&nbsp;
Best Regards,Dale

Forum Discussion

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

2 Replies

Related content

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

The Expression Refers To Multiple Columns. Multiple Columns Cannot Be Converted To A Scalar Value.

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

Multiple OR expression

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