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.
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