Forum Discussion
Fcoatis
Post Patron
7 years agoReference a column in virtual table
Hello All, I´m trying to figure out this: Orders Above 8000 = VAR tempTable = CALCULATETABLE( SUMMARIZE ( Sales; sales[Order Number]; "Sales Amount"; SUMX ( Sales; Sales[Quantity] ...
OwenAuger
Super User
7 years agoJust remove the table name from the column reference:
...
FILTER ( tempTable; [Sales Amount]>=8000 )
...