Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
eHSMarc
New Member

PowerBI Desktop RS: Table Field Not Displaying in DAX Expression

Hi everyone,

I am working with a small data set which in PBIRS desktop that is a connected SharePoint list. All is well with the connection, my data shows up correctly and I have transformed the data to make sure all of my data types are correct. The problem I have is when writing a simple DAX expression and I type my 'table name'[Field] none of the fields from my table show up, only one test measure I created  will display for selection while writing the expression. I find this to be very perplexing behaviour.

 

I have tried AI tools to research the problem and have checked on all of their suggested reasons why this may be occurring.  My model looks good, field names, data types etc. Any ideas what might be causing this issue...? Thanks so much for the suggestions.

 

1 ACCEPTED SOLUTION
LeandroDeodato
Resolver II
Resolver II

try this

LeandroDeodato_0-1722173856261.png

use selectedvalue, or isinscope.

View solution in original post

3 REPLIES 3
LeandroDeodato
Resolver II
Resolver II

try this

LeandroDeodato_0-1722173856261.png

use selectedvalue, or isinscope.

LeandroDeodato
Resolver II
Resolver II

many mensures need others mensures, and others need columns... show your mensure please.

 

These are all of the fields in my table and the data types have all been verified in Power Query.

eHSMarc_1-1722008180712.png

 

 

This is the DAX formula I am trying to use but my fields do not present when I start typing the table name.

eHSMarc_0-1722008145075.png

 

Hopefully this is helpful.

 

marc

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.