Forum Discussion

Fcoatis's avatar
Fcoatis
Post 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] * Sales[Net Price] )
)
)
RETURN
COUNTROWS(
FILTER(
tempTable;
tempTable[Sales Amount]>=8000    -- Here is the problem!
)
)
Need Help
  • OwenAuger's avatar
    OwenAuger
    7 years ago
    Just remove the table name from the column reference:
     
    ...
    FILTER (
    tempTable;
    [Sales Amount]>=8000
)
    ...
     

4 Replies

  • OwenAuger's avatar
    OwenAuger
    Super User
    7 years ago
    Just remove the table name from the column reference:
     
    ...
    FILTER (
    tempTable;
    [Sales Amount]>=8000
)
    ...