Union Dax with selectedcolumns

Question

Hi All,&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I Need one dax measure for creating new table that contains Table A's one column and need to add one Extra Row like any word "xxx".&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; It can created by below dax.Measure_1 = UNION(&nbsp; &nbsp; SELECTCOLUMNS('Table A',"Headers", "Table A"[Name]),&nbsp; &nbsp; DISTINCT(SELECTCOLUMNS('Table A',"Headers","xxx")))&nbsp;&nbsp;This measure creating the xxx inside that new table column.&nbsp;I need to add one more step.&nbsp;&nbsp;If this new column added to the matrix or table visual, i need to show the "xxx" at the top.&nbsp;How to sort that column?&nbsp;Kindly help me.&nbsp;Thanks in advance.

ritaf1983 · Answer

Hi&nbsp;Anonymous&nbsp;
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

anonymous · Answer

Thanks for Reply,&nbsp;&nbsp;The above screenshot is a measure.In this measure contain sort column. if we can easily to sort what row comes first and what row comes last by sort column.&nbsp;I need to apply same scenario in the above scenario.&nbsp;the "xxx" comes first in the table or matrix visual.Kindly help me.

anonymous · Answer

Hi,&nbsp;Anonymous&nbsp;
Have you solved this problem? If not, can you provide a table of non-sensitive data for the related problem, the desired implementation result (it would be best if it can be represented in a table), measures and the implementation logic to help me better understand your requirements rather than screenshots.
&nbsp;
Best Regards,YangCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution to help the other members find it more quickly.If I misunderstand your needs or you still have problems on it, please feel free to let us know.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;&nbsp;How to provide sample data in the Power BI Forum

Forum Discussion

Union Dax with selectedcolumns

3 Replies

Related content

Performance + Understanding: UNION, Append, Merge

SelectedColumns measure

Union function in Power Query

Union - Wrong columns

Remove duplicates from union