Reference a column in virtual table

[Fcoatis]

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!

)

)

[OwenAuger · Accepted solution]

@Fcoatis 

Just remove the table name from the column reference:

...
FILTER (
    tempTable;
    [Sales Amount]>=8000
)
...

[Fcoatis]

@OwenAuger By the way! 

How did you put the answer in this box format?

[OwenAuger]

You're welcome 🙂

Click Insert Code on the toolbar then enter the code:

[Fcoatis]

Seriously???

THANKS!!!!