The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello
I just begin with Power BI
I try to use the measure below but i have the message "L'expression fait référence à plusieurs colonnes. Plusieurs colonnes ne peuvent pas être converties en une valeur scalaire."
What i have to do please?
Student Summary Average Height =
UNION(
ROW("Gender", "F", "Student Average Height", [Average Height F]),
ROW("Gender", "M", "Student Average Height", [Average Height M])
)
Solved! Go to Solution.
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
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.