Column not showing in DAX measure

[Nabha-Ahmed]

Hi everyone,

I’m running into a strange issue while creating a DAX measure.

I have a table that includes a Year column, but when I try to use it inside a measure, the column does not appear in IntelliSense, and if I type it manually, the measure returns an error.

Here is the expression I’m trying to write:

DisplayItem = FORMAT(Table[Year], "0") & " — " & Table[Event

However:

Table[Year] doesn't show up in the field list inside the measure editor.

When I type it manually, I get an error that the column cannot be found or used in this context.

Other columns from the same table appear normally.

I already checked the data type, refreshed the model, and validated relationships.

Has anyone faced this before?

Is there a specific reason why a column would not appear inside a DAX measure while it exists in the model?

Any suggestions would be greatl

y appreciated!

]

[Poojara_D12 · Accepted solution]

Hi @Nabha-Ahmed 

Your column doesn’t show up in the measure because you can’t use a raw column inside a measure. Measures require a single value, but a column contains multiple values, so Power BI hides it and throws an error.

To fix it, wrap the column in something that returns a single value, like SELECTEDVALUE, MAX, etc.:

DisplayItem =
FORMAT(SELECTEDVALUE(Table[Year]), "0") &
" — " &
SELECTEDVALUE(Table[Event])

Nothing is wrong with your model — the problem is the way you're referencing the column.

[Nabha-Ahmed · Accepted solution]

I also tried another approach that worked well for me by using FIRSTNONBLANK.
This function returns a single value from the column, which makes it valid inside a measure.

Here’s the expression:

DisplayItem =
FORMAT(
    FIRSTNONBLANK(Table[Year], 1),
    "0"
)
& " — "
&
FIRSTNONBLANK(Table[Event], 1)

FIRSTNONBLANK is useful when you want Power BI to pick one value from the current filter context without returning errors.

If someone runs into the same issue (column not appearing inside a measure), there are multiple ways to fix it:

• SELECTEDVALUE → best when the context returns only one value

• CONCATENATEX → best when you want to combine multiple values

• FIRSTNONBLANK → simple and reliable when you only need one value from the filtered rows

All of these help you turn a column into a single value that a measure can work with.

Best regard.

Nabha Ahmed. 

Follow Me In LINKEDIN  

www.linkedin.com/in/nabha-ahmed

[Nabha-Ahmed]

Thank you for your interest and help.

When I run the process, this is the message that appears for me

[Poojara_D12 · Accepted solution]

Hi @Nabha-Ahmed 

Your column doesn’t show up in the measure because you can’t use a raw column inside a measure. Measures require a single value, but a column contains multiple values, so Power BI hides it and throws an error.

To fix it, wrap the column in something that returns a single value, like SELECTEDVALUE, MAX, etc.:

DisplayItem =
FORMAT(SELECTEDVALUE(Table[Year]), "0") &
" — " &
SELECTEDVALUE(Table[Event])

Nothing is wrong with your model — the problem is the way you're referencing the column.

[Nabha-Ahmed]

[Nabha-Ahmed]

Hi @Poojara_D12 

thank you so much for help me 

really the "SelectedValue" worked with "Year" and "Event"

[Praful_Potphode]

Hi @Nabha-Ahmed ,

a column cannot be used directly in a measure context,try to wrap it inside an aggregation like MAX,MIN,SELECTEDVALUE.see below:

DisplayItem = FORMAT(SELECTEDVALUE(Table[Year]), "0") & " — " & SELECTEDVALUE(Table[Event])

DisplayItem = FORMAT(MIN(Table[Year]), "0") & " — " & SELECTEDVALUE(MIN[Event])

DisplayItem = FORMAT(MAX(Table[Year]), "0") & " — " & MAX(Table[Event])

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful