topic Re: Comparing 2 Table results dynamically based on filtered scenario value in DAX Commands and Tips

Comparing 2 Table results dynamically based on filtered scenario value

supplychain39 — Fri, 04 Apr 2025 17:47:43 GMT

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.

Re: Comparing 2 Table results dynamically based on filtered scenario value

lbendlin — Sat, 05 Apr 2025 12:44:18 GMT

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

Re: Comparing 2 Table results dynamically based on filtered scenario value

v-echaithra — Mon, 14 Apr 2025 11:46:11 GMT

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.

Re: Comparing 2 Table results dynamically based on filtered scenario value

v-echaithra — Tue, 22 Apr 2025 09:30:51 GMT

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.

Re: Comparing 2 Table results dynamically based on filtered scenario value

v-echaithra — Wed, 30 Apr 2025 06:17:59 GMT

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.