Forum Discussion
Scenario Comparison
Hello, I am trying to create 2 scenario side by side, so users can dynamically choose the values of the slicer to see the impact of each scenario. My main table has 10 products, and each product...
Hi Anonymous ,
It seems that you are getting the right way to the solution that create new disconnected table for slicer. You should modify your measure to :
[total cost measure 1] = calculate('main table'[Total Cost],filter('main table','main table'[product, vendor name] IN {VALUES('Selection 1'[product,vendor name])}))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Anonymous ,
It seems that you are getting the right way to the solution that create new disconnected table for slicer. You should modify your measure to :
[total cost measure 1] = calculate('main table'[Total Cost],filter('main table','main table'[product, vendor name] IN {VALUES('Selection 1'[product,vendor name])}))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai