Dax to show just a column

[BishwaR]

Hypothetically speaking I have a table with 3 columns Product ID, Product Name and Price.

I have to write a dax just to get the Product ID.

I wrote a Dax Product_ID= FILTER(Table_Name,Product ID <> BLANK( )) then it returns an error message saying "The expression refers to multiple columns. Multiple columns cannot be converted into a scalar value"

Thanks

Bishwa

[v-jingzhang]

Hi @BishwaR 

The expected result is not very clear. You want all the non-blank values from this column into a new table, or want an aggregate value (max, min, count...) of this column?

If you want all non-blank unique values from this column, you can add a new table 

Table 2 = SUMMARIZE(FILTER('Table (2)',[Product ID]<>BLANK()),[Product ID])

If you want to keep the duplicate IDs, you can add a new table

Table 2 = SELECTCOLUMNS(FILTER('Table (2)',[Product ID]<>BLANK()),"Product ID",[Product ID])

If these are not what you want, can you share some dummy data and expected result to make it clearer?

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Greg_Deckler]

@BishwaR Dax Product ID = MAX('Table_Name'[Product ID])