Help on my first measure

[jip31]

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])
    )

[Anonymous · Accepted 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

[Anonymous · Accepted 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]

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?

[Anonymous · Accepted solution]

@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]

 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.