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 ...
amitchandak
Super User
Super UserAnonymous , 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
- amitchandak
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.
Hi amitchandak
Please see attached workbook. I want to plot whatever is selected in Numerator and Denominator box in one chart
- amitchandak
Anonymous , attachment missing