Question about DAX intellisense

[Anonymous]

I am new to dax and cant working out why sometimes it see tables and sometimes doesnt?

For example i have this measure and it work just fine 

If want to create new measure - doesnt matter if by right click on table Lucis Suide... or Dax Data it only see dax data measures and one measeure from Lucid Suite table:

Do i need to create reliathionship ? But why it works sometimes works and see all comlumns and tables and sometimes doesnt. IF reliatnsihip is needed then why i was able to create and measure from first screenshot?

[Daniel29195 · Accepted solution]

@Anonymous 

in measures,

you can refer to a column of any table in 2 scenarios :
1.specifying an aggregtated function ( sum, min, max ...) 

2. using iterators ( sumx, filter, minx, maxx, addcolumns, ....  ) 

in able to understand better , read about row context and filter context . 

that is the reason that in your case is only showing measures . 

let me know if this helps . 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠