cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Fcoatis Member
Member

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!
)
)
1 ACCEPTED SOLUTION

Accepted Solutions
OwenAuger Super Contributor
Super Contributor

Re: Reference a column in virtual table

Just remove the table name from the column reference:
 
...
FILTER ( tempTable; [Sales Amount]>=8000 )
...
 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




4 REPLIES 4
OwenAuger Super Contributor
Super Contributor

Re: Reference a column in virtual table

Just remove the table name from the column reference:
 
...
FILTER ( tempTable; [Sales Amount]>=8000 )
...
 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Fcoatis Member
Member

Re: Reference a column in virtual table

Seriously???

THANKS!!!!

Fcoatis Member
Member

Re: Reference a column in virtual table

@OwenAuger By the way! 

How did you put the answer in this box format?

OwenAuger Super Contributor
Super Contributor

Re: Reference a column in virtual table

You're welcome Smiley Happy

 

Click Insert Code on the toolbar then enter the code:image.png

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 39 members 1,072 guests
Please welcome our newest community members: