Forum Discussion
Question about DAX intellisense
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?
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! 🤠
1 Reply
- Daniel29195
Community Champion
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! 🤠