Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |