Forum Discussion

Frequent Visitor

2 years ago

Solved

Combine two column and total

Hello, I have a Dataset with several columns, two of which look like this: | Departure Country | | Arrival Country | | France | | Belgium | | France | ...

Nithinr
2 years ago
To combine two columns as rows in Power BI , you can use the "Unpivot Columns" feature.
Select the columns you want to combine. "Departure Country" and "Arrival Country" that you want to com
bine as rows.
Right-click and choose "Unpivot Columns" from the context menu. This will transform the selected columns into rows.
Rename the new columns as needed .
Create a measure to get count.

Country Count = COUNTAX('Table', [Value])

Icon for Resolver III rank

Resolver III

2 years ago

To combine two columns as rows in Power BI , you can use the "Unpivot Columns" feature.

Select the columns you want to combine. "Departure Country" and "Arrival Country" that you want to com
bine as rows.
Right-click and choose "Unpivot Columns" from the context menu. This will transform the selected columns into rows.
Rename the new columns as needed .
Create a measure to get count.

Country Count = COUNTAX('Table', [Value])