Forum Discussion
Creating table rows based on selected value
Hello there, can you advise how I can create rows in Table A based on filtered values from two different tables - they are Numerator and Denominator.
I created the below (which doesnt work) that is supposed to put Filtered Numerator in row 1, then Denominator in row 2.
Table A = {SELECTEDVALUE('Numerator'[Dataitem]),SELECTEDVALUE('Denominator'[Dataitem])}
8 Replies
Anonymous , You can not use selectedvalue or value from slicer in table creation.
refer various ways to create a table from two tables
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Hi amitchandak , Im looking at your article and it looks like they are combined as separate columns? I want mine to show as separate rows bu the same columns
Anonymous , not very clear .
Union (All(table[column1]),All(table[column2]))
will create two rows for Column 1 and column 2
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
