Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.