Home
Training
Consulting
Articles & Blog
Videos
Books
Tools
About

Menu
Search
0
LOGIN

Home
Training
Consulting
Articles & Blog
Videos
Books
Tools
About

Accept cookies to show this video. Cookies Policy
Allow all cookies

SELECTCOLUMNS – DAX Guide

SELECTCOLUMNS: Returns a table with selected columns from the table and new columns specified by the DAX expressions.
https://dax.guide/selectcolumns/

Jun 16, 2021

LinkedIn Twitter Facebook Email

Subscribe

Comments

You need to login in order to comment this video.

Login Or register

Subscribe

Notify of

Please login to comment

5 Comments

Inline Feedbacks

View all comments

Rick de Groot

1 year ago

Hi there. Something irregular I’ve noticed is the following. See the following code based on DAX.DO:

EVALUATE
VAR BaseTable =
  ADDCOLUMNS ( ‘Product’, “@Products”, CALCULATE ( COUNTROWS ( ‘Product’ ) ) )
VAR Result =
  SELECTCOLUMNS (
    FILTER (
      BaseTable,
      ‘Product'[Product Name] = “Contoso Rechargeable Battery E100 Black”
    ),
    [@Products]
  )
RETURN
  Result

You can create a Column using ADDCOLUMNS, in this case [@Products]

Then if you want to return the already computed value in another SELECTCOLUMNS statement, I try to filter down the table to a single row. Then selectcolumns should return the Value underlying [@products].

However, when writing this it gets underlined with a red line and the message: “Parameter is not the correct type.” However, the result still works. I’m wondering if I wrote something with a syntax error, which causes the code to be underlined.

Regards,
Rick

ps. The picture I added uses a ‘Contract’ table for my own model, but it shows a similar issue.

Error DAX.png

Last edited 1 year ago by Rick de Groot

0

StickClose

Sergio Murru

1 year ago

Reply to Rick de Groot

It’s a known bug. Can you please open a ticket with Microsoft asking to fix it? The more we ask for it, the more they might consider to fix it.

1

Rick de Groot

1 year ago

Reply to Sergio Murru

Thanks Sergio, will do!

1

thurston howell

3 years ago

GOAL: ALIAS a summarized column ( ‘Fact'[BucketGroup])
Note: Not showing all the other variables doing filter to lessen complexity
If I run and evaluate __DS0Core the data is correct. RunTime on 100 MillionRows 1 sec.
However I have to ALIAS a column.

VAR __DS0Core =
    SUMMARIZECOLUMNS(
      ‘dimCustomer'[CustName],
      ‘Fact'[BucketGroup],
      __DS0FilterTable,
      __DS0FilterTable2,
      __DS0FilterTable3,
      __ValueFilterDM0,

      “Total_Orders”, ‘Fact'[Orders]
    )
EVALUATE
  __DS0Core

I have tried several methods but SELECTCOLUMNS should work in theory as I am just selecting the output from table generated by __DS0Core.
The Order Total is now incorrect. I can’t even tell what it is totaling
This seems overcomplex to Alias a column.


//This produces incorrect Order total.  Also unclear why i cant just use the alias “Total_Orders” from __DS0Core
  VAR __DS0PrimaryWindowed =

  SELECTCOLUMNS(
  __DS0Core,
  “Customer”    , ‘dimCustomer'[CustName],
  “High Bucket”    , ‘Fact'[BucketGroup],
  “Total_Orders”, ‘Fact'[Orders]

  )

EVALUATE
__DS0PrimaryWindowed

Also Note I have tried wrapping ADDCOLUMNS to change the name. Takes hours and not correct.
Also note when you copy the DAX from POWERBI, any columns RENAMED in POWERBI are not retained in the DAX

Last edited 3 years ago by thurston howell

1

StickClose

Sergio Murru

3 years ago

Reply to thurston howell

I’m not sure I fully understand the question, but you can find a working sample of a renamed calculated column at the following link in dax.do https://dax.do/R1uhjpBDtum3GM/

<pre>
EVALUATE
VAR TableVar =
SUMMARIZECOLUMNS (
  ‘Customer'[Continent],
  “SalesPerContinent”, [Sales Amount]
)
VAR AliasNameTableVar =
SELECTCOLUMNS (
  TableVar,
  “Continent”, Customer[Continent],
  “SalesRenamed”, [SalesPerContinent]
)
RETURN
  AliasNameTableVar
</pre>

Power BI functionality to rename columns is done on the query results after the DAX query is executed.

0

All

01:50

Collaborate with your Team and Customers with DAX Optimizer

Nov 11, 2024
33:19

Building bullet charts in Power BI reports

Nov 5, 2024
05:01

Improving Semantic Model Developer Productivity using DAX Optimizer

Nov 4, 2024
02:36

Safeguard Data Privacy in DAX Optimizer

Oct 28, 2024
41:01

Using weekly calendars in Power BI

Oct 23, 2024
04:24

Keep Track of Fixed Issues in DAX Optimizer

Oct 21, 2024
03:30

Boost Power BI Efficiency with DAX Optimizer

Oct 14, 2024
20:02

Impact of data types in DAX arithmetical calculations

Oct 8, 2024

Newsletter

By subscribing you are agreeing to our Privacy Policy.

241.3K subscribers

Get BI news and original content in your inbox every 2 weeks!
Newsletter archive

What is next

Mastering DAX – Nov 19
, Amsterdam
Mastering DAX – Dec 2
, Copenhagen
Data Modeling for Power BI – Dec 10
, Amsterdam
Mastering DAX – Feb 11
, Amsterdam
Mastering DAX – Feb 18
, Phoenix
Mastering DAX – Feb 24
, Dallas

YouTube Twitter LinkedIn Facebook Github RSS Feed

Marco Russo Alberto Ferrari Daniele Perilli

2004-2024 © SQLBI. All rights are reserved.
SQLBI is a trademark of SQLBI Corp.
Loader is a European legal entity.

Privacy Policy & Cookies Terms & Conditions Contact Us

You are going to send email to

Move Comment