Forum Discussion
Comparing 2 Table results dynamically based on filtered scenario value
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.
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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
4 Replies
- lbendlin
Super User
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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 
v-echaithraCommunity Support
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. - 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 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.