SELECTCOLUMNS() select only one column doesnt work anymore with PowerBI 2.49

[jinhoff_BFR]

Hello anyone,

(i have posted this already on the "Deskop" Forum, you can find it at: https://community.powerbi.com/t5/Desktop/SELECTCOLUMNS-select-only-one-Column-doesnt-work-anymore-wi...)

i have to add another Column to an Existing Table, this Column has to be the "InternalId" from an Location, this Location has a LocationId. Now i select from an second Table the InternalId, if the LocationIds are the same.

This has worked great, with PowerBI Version 2.48 and the following DAX-Formula:

InternalId = SELECTCOLUMNS(Filter(ALLSELECTED(Locations);Sales[LocationId] = Locations[LocationId]);"InternalId";Locations[InternalId])

Now after the Update to Version 2.49.4831.521 (64 Bit) the Formula doesnt work anymore, it shows an error that its not possible to select more then one Column.

"The expression references multiple columns. Multiple columns can not be converted to a scalar value."

At the following you can see the Tables structure.

Sales:

Id	SalesSum	Month	ArticleId	LocationId	InternalId
1	200€	1	1	1	123456
2	134€	2	3	5	9876

(The InternalId Column should be this Value but it shows only "Error")

Locations:

LocationId	InternalId
1	123456
5	9876

Is it maybe an PowerBi Bug?

Thanks in advance.

Best regards

Jan Inhoff

[aviral]

This is really shocking. 

I am unable to refresh

the dataset due to this

issue and the report is

due in few hours. 

Really bad experience. 

Was able to revert to

the previous version

and trying to update

the dataset with that

now. 

[AlexanderK79]

I have a workaround.... disable the scheduled refresh, download an older version of PowerBI ( https://zenatti.net/2017/07/04/power-bi-previous-versions/ ) desktop, download the .pbix version of your report, refresh and then publish.

This will at least save your business problem :-s

[v-qiuyu-msft]

Hi all, 

Based on my test, the issue is fixed in Power BI desktop 2.51.4885.701 64-bit (October 2017). Please update desktop to this version and test again. 

Best Regards,
Qiuyun Yu

[AlexanderK79]

it works again with the new Power BI version 🙂