topic Column not showing in DAX measure in DAX Commands and Tips

Column not showing in DAX measure

Nabha-Ahmed — Thu, 20 Nov 2025 07:06:01 GMT

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!

]

Re: Column not showing in DAX measure

Praful_Potphode — Thu, 20 Nov 2025 08:06:45 GMT

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

Re: Column not showing in DAX measure

Poojara_D12 — Thu, 20 Nov 2025 08:46:04 GMT

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.

Re: Column not showing in DAX measure

Nabha-Ahmed — Sat, 22 Nov 2025 00:02:50 GMT

Thank you for your interest and help.

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

Re: Column not showing in DAX measure

Nabha-Ahmed — Sat, 22 Nov 2025 00:09:19 GMT

Hi Poojara_D12

thank you so much for help me

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

Re: Column not showing in DAX measure

Nabha-Ahmed — Sat, 22 Nov 2025 00:09:53 GMT

Re: Column not showing in DAX measure

Nabha-Ahmed — Sat, 22 Nov 2025 00:18:40 GMT

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