Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
I was able to get my formulas working using calculated columns.
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.
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.
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
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.
Any Screenshot of error & table relationship would be very benefitial for identifying issue.
I was able to get my formulas working using calculated columns.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |