Forum Discussion

mbd's avatar
mbd
Helper I
8 years ago
Solved

DAX Formula

Hi, 

 

When I am creating a formual with DAX, a dropdown appears with the list of my tables, but not all of my tables. Why is that?

 

Thanks

 

Lorine

Need Help
  • mbd's avatar
    mbd
    8 years ago

    I was able to get my formulas working using calculated columns.

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    It is essentially type ahead/intellisense type functionality so if you start typing typing "t" then the tables and measures that start with "t" will show up.

    • mbd's avatar
      mbd
      Helper I
      8 years ago

      Thanks, but the problem is even as I continue to type in the complete name of the table, it doesn't show up. So when it's typed into the DAX formula the color of the font is grey and I can't use any of the data in the table for calculations.

      • jthomson's avatar
        jthomson
        Solution Sage
        8 years ago

        It could be the case that the relationships in place between tables mean that the one you want doesn't work in the context you're using