Forum Discussion
Extract unique values from multiple columns
Hello Power BI community, I have been trying for some time now to figure out the solution to this problem (I am new to Power BI and DAX) but I could not find the solution myself or on the internet. ...
Hi,
I had a similar need, so i used the following steps:
Created a new table using DAX UNION and DAX SELECTCOLUMNS,
New_table_name=
UNION(
SELECTCOLUMNS(source_table_name,"new_column_name",source_column_name1),
SELECTCOLUMNS(source_table_name,"new_column_name",source_column_name2),
SELECTCOLUMNS(source_table_name,"new_column_name",source_column_name3),
.
.
.
)
this will create a new table, with summarized columns.
On top of this use DAX Measure , DISTINCTCOUNT or COUNTROWS(FILTER(table_name,NOT(ISBLANK(column_name))
This measure will help you to get a pivot table kind of result with individual columns.
From This
to This: