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.

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.

    • FarhanAhmed1984's avatar
      FarhanAhmed1984
      Resolver III
      8 years ago

      Any Screenshot of error & table relationship would be very benefitial for identifying issue.

      • mbd's avatar
        mbd
        Helper I
        8 years ago

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