DAX Formula

[mbd]

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

[Greg_Deckler]

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]

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]

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]

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]

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

[mbd · Accepted solution]

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