Error while using CalculateTable()

[community_pinki]

Hi All,

I am trying to use CalculateTable DAX but getting following error

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

Can Anyone tell me where I am doing wrong.

Thanks...

[Anonymous · Accepted solution]

Hi @community_pinki ,

According to your description,

1. If you want to filter a table by a measure,you may try:

Measure = IF(MAX('Table'[Column]) <= 73, 1,0)

And then apply it to visual-level filter ,set as "is 1" as shown below:

2. If you want to return a calculated table, you could try:

New table = FILTER('Table',[Column]<=73)

3. Just use visual-level filter——is less than or equal to:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@community_pinki , Create a new table not measure. Calculatetable returns a table