Forum Discussion
Simulated Weighted Average Payment Term using What-If Parameter
Hi KB88 ,
Thank you again for the update!Since you have already created a disconnected Vendor table, the key is to ensure you're using that disconnected table in your slicer ,not the one that is linked to SC data.If the slicer is based on a table with a relationship, it will still filter the data and affect the weighted average calculation.
Please double-check that the slicer is pointing to the disconnected Vendor table only. Once that is confirmed, your logic might work correctly across all vendors.
Did you get a chance to review my earlier response? If not, please have a look on it and let us know.
Thank you.
Hi KB88 ,
Thanks for the update! The issue likely comes from the vendor slicer directly filtering your main data table. When that happens, the measure ends up calculating the weighted average only for the selected vendor, instead of all vendors. The key fix is to use a separate, disconnected vendor table for your slicer. This way, the slicer doesn’t filter the data, it just tells the measure which vendor’s payment term to override. Please let us know if you found any solution or workaround.
Thank you for your cooperation.Have a great day!
Regards,
Pallavi.
That is the issue! If I remove filtering from the slicer, I get the correct number I am looking for in that step. I have a separate Vendor Name table that I created for this, that is linked to SC Data via Vendor name. I inserted that into the slicer, but am still getting the incorrect numbers.
Hi KB88 ,
Thank you again for the update!Since you have already created a disconnected Vendor table, the key is to ensure you're using that disconnected table in your slicer ,not the one that is linked to SC data.If the slicer is based on a table with a relationship, it will still filter the data and affect the weighted average calculation.
Please double-check that the slicer is pointing to the disconnected Vendor table only. Once that is confirmed, your logic might work correctly across all vendors.
Did you get a chance to review my earlier response? If not, please have a look on it and let us know.
Thank you.The disconnected worked! One note, I had to make a "simvendor" measure that referenced the disconnected table in an IF statement