Creating table rows based on selected value

[Anonymous]

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])}

[Anonymous]

Hello @Anonymous 
Can you share your data in table format and your expected output?

[Anonymous]

Hi @Anonymous 

Please see attached workbook. I want to plot whatever is selected in Numerator and Denominator box in one chart

[amitchandak]

@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/

[Anonymous]

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.

[Anonymous]

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 

[Anonymous]

@amitchandak 

sorry missed that. here it is

https://drive.google.com/file/d/11BXaxM_3h0Y5scTDHtZFAXkPRLrUtTlN/view?usp=sharing