Forum Discussion
Solved
calculatetable measure is throwing error like multiple columns cannot be converted to scalar value
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 ...
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!
v-xulin-mstf
Community Support
Community SupportHi 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!
issue is fixed & Thanks