calculatetable measure is throwing error like multiple columns cannot be converted to scalar value

[SivaReddy]

 I have created a table in sql server and loaded into powerbi. the table is like

eno	ename	deptno	salary
1	Raja	1	5000
2	kirshore	2	6000
3	Naveen	3	5500
4	Santosh	2	8000
5	Praveen	1	10000

I want output like below using calculatetable measure(required data having deptno=1).

eno	ename	deptno	salary
1	Raja	1	5000
5	Praveen	1	10000

the below measure is throwing error 

CalculateTable = CALCULATETABLE(Department_Groupfunction,Department_Groupfunction[deptno]=1)

error

The expression refers to multiple columns. Multiple columns can't be converted to a scalar value

could you please suggest how to fix this.

[v-xulin-mstf · Accepted solution]

Hi @SivaReddy,

Create calculated table as:

CALCULATETABLE = 
CALCULATETABLE(
    'Table','Table'[deptno]=1
)

Here is the output:

The pbix is attached.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[SivaReddy]

thanks

[SivaReddy]

issue is fixed & Thanks

[ryan_mayu]

@SivaReddy 

why not just add a filter and set deptno =1?

[lbendlin]

You cannot output a table as a measure. You can use CALCULATETABLE as part of your measure calculation steps but you must return a single (scalar) value at the end.