Forum Discussion

Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost Patron
7 years ago
Solved

Reference 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] ...
Need Help
  • OwenAuger's avatar
    OwenAuger
    7 years ago
    Just remove the table name from the column reference:
     
    ...
    FILTER (
    tempTable;
    [Sales Amount]>=8000
)
    ...
     
OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
7 years ago
Just remove the table name from the column reference:
 
...
FILTER (
    tempTable;
    [Sales Amount]>=8000
)
...
 
Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost Patron
7 years ago

Seriously???

THANKS!!!!