Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi @Anonymous
It seems you are creating a measure. For a measure, it should always return a scalar value rather than a table. You should use CALCULATE rather than CALCULATETABLE.
Try a measure like
sales = CALCULATE ( SUM ( 'Sales'[sales] ), 'Sales'[Location] = "Bangalore" )
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
Hi @Anonymous
It seems you are creating a measure. For a measure, it should always return a scalar value rather than a table. You should use CALCULATE rather than CALCULATETABLE.
Try a measure like
sales = CALCULATE ( SUM ( 'Sales'[sales] ), 'Sales'[Location] = "Bangalore" )
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
User | Count |
---|---|
94 | |
92 | |
84 | |
83 | |
49 |
User | Count |
---|---|
150 | |
146 | |
112 | |
73 | |
56 |