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.

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

      • mbd's avatar
        mbd
        Helper I
        8 years ago

        Even if I'm only using data  that is contained only within the table I'm trying to create the measure for?

         

        This table has no relationships to other tables in this file and doesn't need to. This table has everything it needs to calculate the measure.