Comparing 2 Table results dynamically based on filtered scenario value

[supplychain39]

Data Structure: I have 1 data table "SIM_CAPACITY_DETAIL" that has the output from 10 different capacity scenario's that have been ran. The column, "SIMULATION_NAME" is the unique identifier between scenario'sm all other columns are the same. "SUM(RLD.LOADQTY)" is the column of data i'm trying to sum / compare between scenario's.

Currently, both slicers at the top reference the same column in the data.

Help Needed: I want to be able to compare the SUM of "SUM(RLD.LOADQTY)" between two simulations stored in the "SIM_CAPACITY_DETAIL" table based on which scenario is selected in each of the two drop down boxes on the sheet. In the picture, "ALL OUT" is one "Simulation_Name" and "ALL OUT 2.0" is a second. I do not want the formula to reference the exact "SIMULATION_NAME" in this example, more instead the selected value from the filter / drop down list. 

[v-echaithra]

Hi @supplychain39 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra E.

[v-echaithra]

Hi @supplychain39 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra E.

[v-echaithra]

Hi @supplychain39 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if you have found the solution or Let us know if you need any further assistance?

Regards,

Chaithra E.

[lbendlin · Accepted solution]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...