Forum Discussion
Help on my first measure
Hi jip31,
Seems like you created a measure.
Click on Modeling->New table->enter your formula here.Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Husna
jip31 By creating a measure it will return scalar value -->like ex:total sum=1234
UNION functions returns table because of which it is throwing error.You may refer the below link for more details
https://dax.guide/union/Regards,
Husna
Hi jip31,
Seems like you created a measure.
Click on Modeling->New table->enter your formula here.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Husna
Hi
Yes you are right
It works Modeling->New table
But I dont understand why I need to create a new table instead displaying the result in my actual table with a new mesure?
Pearhaps because I use the UNION function?
jip31 By creating a measure it will return scalar value -->like ex:total sum=1234
UNION functions returns table because of which it is throwing error.You may refer the below link for more details
https://dax.guide/union/Regards,
Husna
- AlexisOlson
Super User
A measure must return a single value in any given context. Your formula defines a table so it cannot work as a measure. You can use a measure within a table (e.g. in defining a calculated column) but you cannot create a table with a measure.
