Forum Discussion

eHSMarc's avatar
eHSMarc
New Member
2 years ago
Solved

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.

 

3 Replies

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

    • eHSMarc's avatar
      eHSMarc
      New Member

       

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

       

       

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

       

      Hopefully this is helpful.

       

      marc