DAX ; how MIN / MAX see data model

[dicken]

Hi, this is more a a theory question than practical;
in the measure ;

Tbetween:=CALCULATE([TotalUnits], 
                                    FILTER(ALL(Table1[Units]), 
                                                         Table1[Units] <= MAX(Table3[Max]) && Table1[Units] >= MIN(Table3[Min])  ) )

These two tables are not connected, and if you just use the comparison operator Table1 cannont 'see' Table3 , but as soon as you use
MIN or MAX the Table3 columns show up in the intelisense options, the MS docs does not have any info on who this works,
any information or direction to where it could be found would be appreciated.

Richard.

 

[Misca]

I am not a DAX pro but I believe the reason is a table can't "see" disconnected tables but when you use functions that return values instead of tables you're not working with disconnected tables anymore but numbers. And in DAX ( Excel in general ) a number is a number no matter how you get it.

If you want to create a connection between the tables you can try using the TREATAS function to create one.

 

[dicken]

I am not a DAX pro but I believe the reason is a table can't "see" disconnected tables but when you use functions that return values instead of tables you're not working with disconnected tables anymore but numbers. And in DAX ( Excel in general ) a number is a number no matter how you get it.

If you want to create a connection between the tables you can try using the TREATAS function to create one.

That sort of makes sense in a DAX sort of way, I don't need them connected and have never lived TREATAS as I don't really understand how it works, this was more of a ' I wonder why ' than of practical use, one of those things like VALUES(table) with one value behaves like a scaler for filtering.
Happy Christmas.
I'll leave this open and see if I get other answers just for the moment.

Richard.