Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to create a new calculated table based on another table:
"ASINs" and "SKUs" columns from source table would be combined into a single "ASINs & SKUs" column of the calculated table (distinct values and excluding blanks from both "ASINs" and "SKUs" source columns), while repeating the respective "Key" column. Other columns (Data 1, 2, 3..) would be ignored.
I have tried the following, but the expression didn't work claiming "A table of multiple values was supplied where a single value was expected."
Calculated Table = SELECTCOLUMNS(Source Table, "Key", Source Table[Key], "ASINs & SKUs", UNION(VALUES(Source Table[ASIN]), VALUES(Source Table[SKU])))
Thanks in advance for your help!
Solved! Go to Solution.
Hi @devitus
The UNION function needs you to supply the whole table, not just a particular column
Try this:
VAR _Unioned =
UNION(
SELECTCOLUMNS(
FILTER('Table', NOT ISBLANK('Table'[ASINs])),
"Key", 'Table'[Key], "ASINS & SKUs", 'Table'[ASINs]
),
SELECTCOLUMNS(
FILTER('Table', NOT ISBLANK('Table'[SKUs])),
"Key", 'Table'[Key], "ASINS & SKUs", 'Table'[SKUs])
)
VAR _Distinct =
SUMMARIZE(
_Unioned,
[Key], [ASINS & SKUs]
)
Hi @devitus
The UNION function needs you to supply the whole table, not just a particular column
Try this:
VAR _Unioned =
UNION(
SELECTCOLUMNS(
FILTER('Table', NOT ISBLANK('Table'[ASINs])),
"Key", 'Table'[Key], "ASINS & SKUs", 'Table'[ASINs]
),
SELECTCOLUMNS(
FILTER('Table', NOT ISBLANK('Table'[SKUs])),
"Key", 'Table'[Key], "ASINS & SKUs", 'Table'[SKUs])
)
VAR _Distinct =
SUMMARIZE(
_Unioned,
[Key], [ASINS & SKUs]
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |