store selected values slicer and store in calculated table

[Anonymous]

Hi Team ,

we do have a requirement to capure costs for multiple selected values in the slicer and calulate delta.

lets say users selects jan, mar and june then we need to calulate the cost for jan, mar and june 

the delta for mar should be (mar cost-jan cost)/mar cost

delta for june should be (jun cost-mar cost)/jun cost.

Tried using slected value it is working for single selection but not for multiple selections.

Appreciate if any one helps in this .

[Anonymous]

Hi @Anonymous ,

The first point to note is that the calculated table does not change dynamically with the slicer options. If you want to display different results by selecting different options, you can create measure in combination with table visuals to do so.  In order to provide you with a suitable solution, could you please share some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

How to upload PBI in Community

Best Regards